Найти в Дзене
72 подписчика

--План выполнения тестового запроса -TEMPORARY TABLE

 Sort (cost=2211998.73..2215844.96 rows=1538491 width=98) (actual time=34246.862..34542.140 rows=1211093 loops=1)
  Sort Key: b.book_date, t.ticket_no
  Sort Method: external merge Disk: 109672kB
  -> Hash Left Join (cost=579129.28..1925563.26 rows=1538491 width=98) (actual time=23831.991..32643.918 rows=1211093 loops=1)
   Hash Cond: (s.flight_id = f.flight_id)
   -> Merge Right Join (cost=575526.49..1917921.78 rows=1538491 width=74) (actual time=23774.473..31882.934 rows=1211093 loops=1)
   Merge Cond: (s.ticket_no = t.ticket_no)
   -> Merge Left Join (cost=1.12..1264914.56 rows=20598448 width=25) (actual time=2.411..22735.924 rows=3430362 loops=1)
   Merge Cond: ((s.ticket_no = bp.ticket_no) AND (s.flight_id = bp.flight_id))
   -> Index Only Scan using segments_pkey on segments s (cost=0.56..424624.50 rows=20598448 width=18) (actual time=1.704..1121.887 rows=3430362 loops=1)
   Heap Fetches: 0
   -> Index Scan using boarding_passes_pkey on boarding_passes bp (cost=0.56..637941.32 rows=19870556 width=25) (actual time=0.698..18861.672 rows=3430362 loops=1)
   -> Materialize (cost=575525.37..581342.10 rows=1163347 width=63) (actual time=6939.314..7652.509 rows=1211093 loops=1)
   -> Sort (cost=575525.37..578433.73 rows=1163347 width=63) (actual time=6939.289..7437.005 rows=902132 loops=1)
   Sort Key: t.ticket_no
   Sort Method: external merge Disk: 47192kB
   -> Nested Loop Left Join (cost=0.43..432700.18 rows=1163347 width=63) (actual time=0.175..4432.691 rows=902132 loops=1)
   -> Seq Scan on temp_filtered_bookings b (cost=0.00..6791.41 rows=410341 width=36) (actual time=0.096..71.373 rows=410341 loops=1)
   -> Index Scan using idx_tickets_book_ref on tickets t (cost=0.43..1.01 rows=3 width=34) (actual time=0.009..0.010 rows=2 loops=410341)
   Index Cond: (book_ref = b.book_ref)
   -> Hash (cost=2247.35..2247.35 rows=108435 width=28) (actual time=57.236..57.238 rows=108435 loops=1)
   Buckets: 131072 Batches: 1 Memory Usage: 7377kB
   -> Seq Scan on flights f (cost=0.00..2247.35 rows=108435 width=28) (actual time=0.055..24.930 rows=108435 loops=1)
 Planning Time: 42.697 ms
 Execution Time: 34655.641 ms
1 минута