explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6NaU

Settings
# exclusive inclusive rows x rows loops node
1. 17.414 707.338 ↑ 7.0 8,564 1

Merge Left Join (cost=9.870..15,596,686.590 rows=59,899 width=105) (actual time=9.634..707.338 rows=8,564 loops=1)

  • Merge Cond: (november_echo.zulu = mike_juliet.zulu)
  • Join Filter: (mike_juliet.echo_six = (delta_four 10))
  • Rows Removed by Join Filter: 891
  • Buffers: shared hit=127828 read=6658
  • I/O Timings: read=229.516
2. 292.192 655.554 ↑ 7.0 8,564 1

Merge Join (cost=9.600..13,584,784.650 rows=59,899 width=82) (actual time=0.102..655.554 rows=8,564 loops=1)

  • Merge Cond: (papa.zulu = sierra.zulu)
  • Join Filter: ((sierra.golf_delta >= november_echo.three_papa) AND ((sierra.three_foxtrot = ANY ('oscar'::numeric[])) OR (three_delta: delta_four 5 or mike_mike delta_four 6)) AND ((NOT (delta_four 7)) OR (sierra.golf_delta < (delta_four 8))))
  • Rows Removed by Join Filter: 669304
  • Buffers: shared hit=112337 read=6327
  • I/O Timings: read=212.236
3. 6.548 51.856 ↑ 1.0 13,850 1

Nested Loop Left Join (cost=9.170..233,172.230 rows=13,850 width=61) (actual time=0.051..51.856 rows=13,850 loops=1)

  • Buffers: shared hit=33317 read=18
  • I/O Timings: read=0.348
4. 8.760 17.608 ↑ 1.0 13,850 1

Merge Join (cost=0.570..2,673.610 rows=13,850 width=53) (actual time=0.021..17.608 rows=13,850 loops=1)

  • Merge Cond: (november_echo.zulu = papa.zulu)
  • Buffers: shared hit=5203 read=18
  • I/O Timings: read=0.348
5. 4.522 4.522 ↑ 1.0 13,850 1

Index Scan using whiskey on echo_lima november_echo (cost=0.290..1,242.840 rows=13,850 width=30) (actual time=0.010..4.522 rows=13,850 loops=1)

  • Buffers: shared hit=3065 read=1
  • I/O Timings: read=0.023
6. 4.326 4.326 ↑ 1.0 13,764 1

Index Scan using alpha_mike on uniform papa (cost=0.290..1,223.230 rows=13,764 width=23) (actual time=0.005..4.326 rows=13,764 loops=1)

  • Buffers: shared hit=2138 read=17
  • I/O Timings: read=0.325
7. 0.000 27.700 ↓ 0.0 0 13,850

Limit (cost=8.600..16.620 rows=1 width=4,304) (actual time=0.002..0.002 rows=0 loops=13,850)

  • Buffers: shared hit=28114
8.          

Initplan (for Limit)

9. 0.000 27.700 ↑ 1.0 1 13,850

Result (cost=8.310..8.320 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=13,850)

  • Buffers: shared hit=27843
10.          

Initplan (for Result)

11. 13.850 27.700 ↓ 0.0 0 13,850

Limit (cost=0.290..8.310 rows=1 width=5) (actual time=0.002..0.002 rows=0 loops=13,850)

  • Buffers: shared hit=27843
12. 13.850 13.850 ↓ 0.0 0 13,850

Index Only Scan using whiskey on echo_lima alpha_seven (cost=0.290..8.310 rows=1 width=5) (actual time=0.001..0.001 rows=0 loops=13,850)

  • Index Cond: ((zulu = $18) AND (five_foxtrot five_romeo NOT NULL) AND (five_foxtrot > $19))
  • Heap Fetches: 90
  • Buffers: shared hit=27843
13. 0.000 0.000 ↓ 0.0 0 13,850

Index Scan using whiskey on echo_lima quebec (cost=0.290..8.300 rows=1 width=4,304) (actual time=0.000..0.000 rows=0 loops=13,850)

  • Index Cond: ((zulu = november_echo.zulu) AND (five_foxtrot = $21))
  • Buffers: shared hit=271
14. 149.407 149.407 ↓ 1.3 677,876 1

Index Scan using xray_seven on kilo_alpha sierra (cost=0.420..38,679.670 rows=527,356 width=26) (actual time=0.008..149.407 rows=677,876 loops=1)

  • Buffers: shared hit=54355 read=3204
  • I/O Timings: read=42.815
15.          

SubPlan (for Merge Join)

16. 0.000 0.000 ↓ 0.0 0

Index Scan using bravo on victor delta_whiskey (cost=0.420..8.440 rows=1 width=0) (never executed)

  • Index Cond: ((zulu = november_echo.zulu) AND (golf_delta = sierra.golf_delta))
  • Filter: (golf_whiskey = ANY ('lima'::numeric[]))
17. 52.971 152.109 ↑ 136.0 1 1

Gather (cost=1,000.000..12,087.300 rows=136 width=13) (actual time=49.808..152.109 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=5428 read=3105
  • I/O Timings: read=169.074
18. 99.138 99.138 ↓ 0.0 0 3

Parallel Seq Scan on victor delta_bravo (cost=0.000..11,073.700 rows=57 width=13) (actual time=65.126..99.138 rows=0 loops=3)

  • Filter: (golf_whiskey = ANY ('lima'::numeric[]))
  • Rows Removed by Filter: 162605
  • Buffers: shared hit=5428 read=3105
  • I/O Timings: read=169.074
19. 8.820 8.820 ↓ 0.0 0 8,820

Index Only Scan using whiskey on echo_lima six (cost=0.290..8.300 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=8,820)

  • Index Cond: ((zulu = sierra.zulu) AND (five_foxtrot > november_echo.five_foxtrot))
  • Heap Fetches: 390
  • Buffers: shared hit=18063
20. 0.390 1.170 ↑ 1.0 1 390

Aggregate (cost=8.310..8.320 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=390)

  • Buffers: shared hit=1174
21. 0.780 0.780 ↓ 2.0 2 390

Index Scan using whiskey on echo_lima charlie (cost=0.290..8.300 rows=1 width=8) (actual time=0.002..0.002 rows=2 loops=390)

  • Index Cond: ((zulu = sierra.zulu) AND (five_foxtrot > november_echo.five_foxtrot))
  • Buffers: shared hit=1174
22. 0.098 0.301 ↓ 2.9 892 1

Materialize (cost=0.270..37.700 rows=312 width=32) (actual time=0.124..0.301 rows=892 loops=1)

  • Buffers: shared hit=54
23. 0.203 0.203 ↑ 1.0 312 1

Index Scan using juliet on mike_whiskey mike_juliet (cost=0.270..36.920 rows=312 width=32) (actual time=0.113..0.203 rows=312 loops=1)

  • Buffers: shared hit=54
24.          

SubPlan (for Merge Left Join)

25. 0.000 2.412 ↑ 1.0 1 1,206

Result (cost=8.290..8.300 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=1,206)

  • Buffers: shared hit=3288
26.          

Initplan (for Result)

27. 0.000 2.412 ↑ 1.0 1 1,206

Limit (cost=0.270..8.290 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1,206)

  • Buffers: shared hit=3288
28. 2.412 2.412 ↑ 1.0 1 1,206

Index Only Scan using juliet on mike_whiskey golf_six (cost=0.270..8.290 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1,206)

  • Index Cond: ((zulu = sierra.zulu) AND (echo_six five_romeo NOT NULL) AND (echo_six > sierra.golf_delta))
  • Heap Fetches: 874
  • Buffers: shared hit=3288
29. 0.280 0.280 ↑ 1.0 1 140

Index Scan using alpha_mike on uniform tango (cost=0.290..8.300 rows=1 width=6) (actual time=0.002..0.002 rows=1 loops=140)

  • Index Cond: (zulu = november_echo.zulu)
  • Buffers: shared hit=420
30. 0.282 0.282 ↑ 1.0 1 141

Index Scan using alpha_mike on uniform foxtrot (cost=0.290..8.300 rows=1 width=6) (actual time=0.002..0.002 rows=1 loops=141)

  • Index Cond: (zulu = november_echo.zulu)
  • Buffers: shared hit=423
31. 0.000 8.271 ↑ 1.0 1 919

Aggregate (cost=8.310..8.320 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=919)

  • Buffers: shared hit=2778 read=86
  • I/O Timings: read=4.650
32. 8.271 8.271 ↑ 1.0 1 919

Index Scan using alpha_kilo on romeo_four xray_india (cost=0.290..8.310 rows=1 width=8) (actual time=0.008..0.009 rows=1 loops=919)

  • Index Cond: ((zulu = november_echo.zulu) AND (golf_delta = november_echo.three_papa))
  • Filter: (kilo_whiskey = 'kilo_tango'::numeric)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=2778 read=86
  • I/O Timings: read=4.650
33. 2.853 22.824 ↑ 1.0 1 2,853

Aggregate (cost=8.310..8.320 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=2,853)

  • Buffers: shared hit=8528 read=245
  • I/O Timings: read=12.630
34. 19.971 19.971 ↑ 1.0 1 2,853

Index Scan using alpha_kilo on romeo_four november_five (cost=0.290..8.310 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=2,853)

  • Index Cond: ((zulu = november_echo.zulu) AND (golf_delta = november_echo.three_papa))
  • Filter: (kilo_whiskey = 'romeo_six'::numeric)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=8528 read=245
  • I/O Timings: read=12.630
Planning time : 4.972 ms
Execution time : 711.724 ms