explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nouX

Settings
# exclusive inclusive rows x rows loops node
1. 1.411 61,917.864 ↑ 1.0 1 1

Aggregate (cost=4,871,399.090..4,871,399.100 rows=1 width=8) (actual time=61,917.864..61,917.864 rows=1 loops=1)

  • Buffers: shared hit=656 read=2295153, temp read=127579 written=127577
2. 15,420.699 61,916.453 ↑ 199.9 14,418 1

Hash Join (cost=1,144,990.200..4,864,193.180 rows=2,882,364 width=4) (actual time=10,541.049..61,916.453 rows=14,418 loops=1)

  • Hash Cond: (sierra_three.papa = november_uniform.papa)
  • Buffers: shared hit=656 read=2295153, temp read=127579 written=127577
3. 36,300.775 36,300.775 ↓ 1.0 86,888,817 1

Seq Scan on five_whiskey sierra_three (cost=0.000..2,692,865.700 rows=86,141,240 width=8) (actual time=0.011..36,300.775 rows=86,888,817 loops=1)

  • Filter: ((three five_romeo NULL) OR (three = 'echo_whiskey'::integer))
  • Rows Removed by Filter: 6210008
  • Buffers: shared hit=32 read=1528910
4. 29.934 10,194.979 ↑ 2.9 131,111 1

Hash (cost=1,138,676.230..1,138,676.230 rows=384,798 width=4) (actual time=10,194.979..10,194.979 rows=131,111 loops=1)

  • Buckets: 524288 Batches: 2 Memory Usage: 6403kB
  • Buffers: shared hit=621 read=766243, temp written=191
5. 1,648.039 10,165.045 ↑ 2.9 131,111 1

Hash Join (cost=612,247.200..1,138,676.230 rows=384,798 width=4) (actual time=5,689.945..10,165.045 rows=131,111 loops=1)

  • Hash Cond: (november_uniform.golf_tango = five_hotel.golf_tango)
  • Buffers: shared hit=621 read=766243
6. 2,834.535 2,834.535 ↓ 1.0 11,511,062 1

Seq Scan on echo_foxtrot november_uniform (cost=0.000..479,456.300 rows=11,499,930 width=8) (actual time=0.941..2,834.535 rows=11,511,062 loops=1)

  • Buffers: shared hit=31 read=364426
7. 15.878 5,682.471 ↑ 2.4 66,618 1

Hash (cost=610,264.640..610,264.640 rows=158,605 width=4) (actual time=5,682.471..5,682.471 rows=66,618 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 4391kB
  • Buffers: shared hit=590 read=401817
8. 860.373 5,666.593 ↑ 2.4 66,618 1

Hash Join (cost=410,457.600..610,264.640 rows=158,605 width=4) (actual time=3,686.684..5,666.593 rows=66,618 loops=1)

  • Hash Cond: (five_hotel.india = sierra_mike.india)
  • Buffers: shared hit=590 read=401817
9. 1,124.155 1,124.155 ↓ 1.0 4,763,972 1

Seq Scan on xray five_hotel (cost=0.000..180,445.990 rows=4,739,999 width=8) (actual time=1.380..1,124.155 rows=4,763,972 loops=1)

  • Buffers: shared hit=225 read=132821
10. 16.343 3,682.065 ↑ 2.3 63,888 1

Hash (cost=408,631.920..408,631.920 rows=146,055 width=4) (actual time=3,682.065..3,682.065 rows=63,888 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 4295kB
  • Buffers: shared hit=365 read=268996
11. 68.094 3,665.722 ↑ 2.3 63,888 1

Hash Join (cost=170,610.860..408,631.920 rows=146,055 width=4) (actual time=1,260.195..3,665.722 rows=63,888 loops=1)

  • Hash Cond: (sierra_mike.mike = hotel_quebec.mike)
  • Buffers: shared hit=365 read=268996
12. 1,084.492 3,502.796 ↑ 1.3 219,486 1

Hash Join (cost=162,078.060..397,560.750 rows=287,415 width=8) (actual time=1,164.857..3,502.796 rows=219,486 loops=1)

  • Hash Cond: (sierra_mike.foxtrot = echo_quebec.foxtrot)
  • Buffers: shared hit=346 read=265312
13. 1,263.150 1,263.150 ↑ 1.0 4,361,954 1

Seq Scan on zulu sierra_mike (cost=0.000..216,242.290 rows=4,364,929 width=12) (actual time=1.389..1,263.150 rows=4,361,954 loops=1)

  • Buffers: shared hit=24 read=172569
14. 47.908 1,155.154 ↑ 1.3 219,486 1

Hash (cost=158,488.160..158,488.160 rows=287,192 width=4) (actual time=1,155.154..1,155.154 rows=219,486 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 11813kB
  • Buffers: shared hit=322 read=92743
15. 1,107.246 1,107.246 ↑ 1.3 219,486 1

Seq Scan on victor echo_quebec (cost=0.000..158,488.160 rows=287,192 width=4) (actual time=0.135..1,107.246 rows=219,486 loops=1)

  • Filter: (((quebec)::text <> 'sierra_five'::text) AND (hotel_uniform >= 'bravo'::date))
  • Rows Removed by Filter: 4142468
  • Buffers: shared hit=322 read=92743
16. 23.307 94.832 ↑ 1.0 121,593 1

Hash (cost=7,006.630..7,006.630 rows=122,094 width=4) (actual time=94.832..94.832 rows=121,593 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 5299kB
  • Buffers: shared hit=19 read=3684
17. 71.525 71.525 ↑ 1.0 121,593 1

Seq Scan on oscar hotel_quebec (cost=0.000..7,006.630 rows=122,094 width=4) (actual time=0.019..71.525 rows=121,593 loops=1)

  • Filter: (tango <> november_november ('golf_zulu'::integer[]))
  • Rows Removed by Filter: 118671
  • Buffers: shared hit=19 read=3684
Planning time : 8.251 ms
Execution time : 61,919.411 ms