explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N64D

Settings
# exclusive inclusive rows x rows loops node
1. 238.382 8,780.286 ↓ 19.7 1,912 1

Nested Loop Semi Join (cost=55,456.500..143,252.240 rows=97 width=214) (actual time=561.861..8,780.286 rows=1,912 loops=1)

2. 1,180.721 2,270.204 ↓ 20.4 313,585 1

Hash Join (cost=55,456.070..99,566.860 rows=15,407 width=222) (actual time=438.965..2,270.204 rows=313,585 loops=1)

  • Hash Cond: (six.zulu_lima = "five".quebec)
3. 650.610 650.610 ↓ 1.0 1,904,756 1

Seq Scan on six (cost=0.000..36,819.790 rows=1,903,179 width=16) (actual time=0.011..650.610 rows=1,904,756 loops=1)

4. 116.653 438.873 ↓ 17.0 133,409 1

Hash (cost=55,358.120..55,358.120 rows=7,836 width=214) (actual time=438.873..438.873 rows=133,409 loops=1)

  • Buckets: 32768 (originally 8192) Batches: 8 (originally 1) Memory Usage: 3841kB
5. 322.220 322.220 ↓ 17.0 133,409 1

Seq Scan on five (cost=0.000..55,358.120 rows=7,836 width=214) (actual time=0.013..322.220 rows=133,409 loops=1)

  • Filter: (zulu_mike AND delta AND (juliet = 2))
  • Rows Removed by Filter: 836369
6. 6,271.700 6,271.700 ↓ 0.0 0 313,585

Index Scan using golf on yankee uniform_foxtrot (cost=0.430..2.840 rows=1 width=8) (actual time=0.020..0.020 rows=0 loops=313,585)

  • Index Cond: (uniform_whiskey = six.whiskey_three)
  • Filter: (whiskey_four = 'papa'::date)
  • Rows Removed by Filter: 8
Planning time : 1.438 ms
Execution time : 8,780.904 ms