explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OpBq

Settings
# exclusive inclusive rows x rows loops node
1. 2.277 787.929 ↑ 1.0 1 1

Aggregate (cost=34,296.170..34,296.210 rows=1 width=24) (actual time=787.928..787.929 rows=1 loops=1)

2. 0.616 90.112 ↓ 9.0 830 1

Nested Loop Left Join (cost=15,904.300..18,257.080 rows=92 width=163) (actual time=42.152..90.112 rows=830 loops=1)

3. 1.150 87.836 ↓ 9.0 830 1

Nested Loop Left Join (cost=15,904.010..18,212.000 rows=92 width=159) (actual time=42.144..87.836 rows=830 loops=1)

4. 1.115 85.856 ↓ 9.0 830 1

Nested Loop (cost=15,903.720..17,911.100 rows=92 width=155) (actual time=42.128..85.856 rows=830 loops=1)

5. 27.301 82.251 ↓ 1.5 830 1

Hash Join (cost=15,903.440..17,724.230 rows=552 width=4) (actual time=42.084..82.251 rows=830 loops=1)

  • Hash Cond: (tango_charlie.tango_delta = india_alpha.quebec_seven)
6. 23.093 23.093 ↑ 1.0 99,177 1

Seq Scan on tango_charlie (cost=0.000..1,560.300 rows=99,230 width=8) (actual time=0.010..23.093 rows=99,177 loops=1)

7. 0.288 31.857 ↑ 1.0 701 1

Hash (cost=15,894.270..15,894.270 rows=733 width=4) (actual time=31.856..31.857 rows=701 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
8. 31.569 31.569 ↑ 1.0 701 1

Seq Scan on india_alpha (cost=0.000..15,894.270 rows=733 width=4) (actual time=1.284..31.569 rows=701 loops=1)

  • Filter: (quebec_foxtrot = 1040655273)
  • Rows Removed by Filter: 131162
9. 2.490 2.490 ↑ 1.0 1 830

Index Scan using mike_tango on charlie five_hotel (cost=0.290..0.340 rows=1 width=155) (actual time=0.003..0.003 rows=1 loops=830)

  • Index Cond: (quebec_seven = tango_charlie.foxtrot_yankee)
  • Filter: (india_four = 774527742)
10. 0.830 0.830 ↓ 0.0 0 830

Index Scan using mike_bravo on tango_november kilo_foxtrot (cost=0.290..3.270 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=830)

  • Index Cond: (quebec_seven = five_hotel.foxtrot_whiskey)
11. 1.660 1.660 ↑ 1.0 1 830

Index Scan using alpha_juliet on alpha_hotel juliet_xray (cost=0.280..0.490 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=830)

  • Index Cond: (quebec_seven = five_hotel.delta_india)
12.          

SubPlan (for Aggregate)

13. 114.024 695.540 ↓ 0.0 0 830

Nested Loop (cost=0.840..174.170 rows=1 width=0) (actual time=0.838..0.838 rows=0 loops=830)

14. 140.270 140.270 ↓ 19.0 266 830

Index Only Scan using delta_seven on tango_charlie lima (cost=0.420..52.660 rows=14 width=4) (actual time=0.006..0.169 rows=266 loops=830)

  • Index Cond: (foxtrot_yankee = five_hotel.quebec_seven)
  • Heap Fetches: 218104
15. 441.246 441.246 ↓ 0.0 0 220,623

Index Scan using romeo on india_alpha quebec_sierra (cost=0.420..8.450 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=220,623)

  • Index Cond: (quebec_seven = lima.tango_delta)
  • Filter: ((quebec_foxtrot = 1040655273) AND (five_echo("juliet_oscar") >= 'zulu_foxtrot'::date) AND (five_echo("juliet_oscar") <= 'bravo'::date))
  • Rows Removed by Filter: 1
16. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=16,483.160..18,303.950 rows=3 width=4) (never executed)

  • Hash Cond: (mike_hotel1.tango_delta = golf1.quebec_seven)
17. 0.000 0.000 ↓ 0.0 0

Seq Scan on tango_charlie kilo_yankee (cost=0.000..1,560.300 rows=99,230 width=8) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Hash (cost=16,483.110..16,483.110 rows=4 width=4) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.000..16,483.110 rows=4 width=4) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
20. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on india_alpha zulu_zulu (cost=0.000..15,482.710 rows=2 width=4) (never executed)

  • Filter: ((quebec_foxtrot = 1040655273) AND (five_echo("juliet_oscar") >= 'zulu_foxtrot'::date) AND (five_echo("juliet_oscar") <= 'bravo'::date))
Planning time : 1.253 ms
Execution time : 788.216 ms