explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WjTq

Settings
# exclusive inclusive rows x rows loops node
1. 49.921 75,428.071 ↑ 1.0 1 1

Aggregate (cost=703,541.740..703,541.750 rows=1 width=0) (actual time=75,428.071..75,428.071 rows=1 loops=1)

2. 120.897 75,378.150 ↓ 1.0 141,666 1

Hash Left Join (cost=221,585.120..703,203.040 rows=135,479 width=0) (actual time=3,665.440..75,378.150 rows=141,666 loops=1)

  • Hash Cond: ((sierra.hotel_oscar)::text = (november.romeo_bravo)::text)
3. 223.963 75,256.456 ↓ 1.0 141,666 1

Nested Loop Left Join (cost=221,481.450..701,236.530 rows=135,479 width=25) (actual time=3,664.623..75,256.456 rows=141,666 loops=1)

  • Join Filter: ((golf.five)::text = (sierra.five)::text)
4. 606.191 61,857.555 ↓ 1.0 141,666 1

Hash Join (cost=221,480.890..526,263.130 rows=135,479 width=50) (actual time=3,664.149..61,857.555 rows=141,666 loops=1)

  • Hash Cond: ((golf.hotel_whiskey)::text = (zulu.quebec)::text)
5. 57,599.980 57,644.206 ↓ 1.0 141,971 1

Bitmap Heap Scan on golf (cost=4,347.970..290,350.090 rows=135,666 width=50) (actual time=49.594..57,644.206 rows=141,971 loops=1)

  • Recheck Cond: ((five)::text = 'seven'::text)
  • Rows Removed by Index Recheck: 2744398
  • Heap Blocks: exact=29979 lossy=80149
6. 44.226 44.226 ↓ 1.0 141,971 1

Bitmap Index Scan on yankee (cost=0.000..4,314.060 rows=135,666 width=0) (actual time=44.226..44.226 rows=141,971 loops=1)

  • Index Cond: ((five)::text = 'seven'::text)
7. 921.730 3,607.158 ↑ 1.0 2,061,738 1

Hash (cost=177,259.860..177,259.860 rows=2,062,085 width=25) (actual time=3,607.158..3,607.158 rows=2,061,738 loops=1)

  • Buckets: 65536 Batches: 64 Memory Usage: 2319kB
8. 2,685.428 2,685.428 ↑ 1.0 2,061,738 1

Seq Scan on zulu (cost=0.000..177,259.860 rows=2,062,085 width=25) (actual time=0.009..2,685.428 rows=2,061,738 loops=1)

  • Filter: ((romeo_zulu)::text = ANY ('victor'::text[]))
  • Rows Removed by Filter: 3544
9. 13,174.938 13,174.938 ↑ 1.0 1 141,666

Index Only Scan using foxtrot on sierra (cost=0.560..1.280 rows=1 width=75) (actual time=0.093..0.093 rows=1 loops=141,666)

  • Index Cond: ((five = 'seven'::text) AND (hotel_whiskey = (zulu.quebec)::text))
  • Heap Fetches: 111066
10. 0.344 0.797 ↑ 1.0 652 1

Hash (cost=95.520..95.520 rows=652 width=25) (actual time=0.797..0.797 rows=652 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 45kB
11. 0.453 0.453 ↑ 1.0 652 1

Seq Scan on november (cost=0.000..95.520 rows=652 width=25) (actual time=0.004..0.453 rows=652 loops=1)