explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GUGO

Settings
# exclusive inclusive rows x rows loops node
1. 995.718 8,754.091 ↑ 2.7 2,449 1

Group (cost=238,269.580..14,998,220.950 rows=6,594 width=1,422) (actual time=6,070.132..8,754.091 rows=2,449 loops=1)

  • Group Key: tango.quebec_seven
2.          

Initplan (forGroup)

3. 8.963 3,635.485 ↑ 1.0 1 1

Aggregate (cost=2,296.480..2,296.500 rows=1 width=1) (actual time=3,635.485..3,635.485 rows=1 loops=1)

4. 4.153 3,626.522 ↓ 13.8 27,106 1

Nested Loop (cost=1.190..2,281.700 rows=1,971 width=8) (actual time=0.065..3,626.522 rows=27,106 loops=1)

5. 3.067 13.331 ↓ 14.3 3,694 1

Merge Join (cost=0.910..650.230 rows=258 width=8) (actual time=0.057..13.331 rows=3,694 loops=1)

  • Merge Cond: (golf_yankee.quebec_seven = lima_delta.sierra)
6. 8.403 8.403 ↑ 1.0 3,977 1

Index Only Scan using two_hotel on oscar_five golf_yankee (cost=0.280..410.630 rows=4,001 width=4) (actual time=0.032..8.403 rows=3,977 loops=1)

  • Heap Fetches: 2012
7. 1.861 1.861 ↓ 1.0 3,694 1

Index Only Scan using papa_xray on tango lima_delta (cost=0.410..3,257.760 rows=3,676 width=4) (actual time=0.021..1.861 rows=3,694 loops=1)

  • Index Cond: (sierra five_romeo_foxtrot NOT NULL)
  • Heap Fetches: 926
8. 3,609.038 3,609.038 ↑ 1.1 7 3,694

Index Scan using zulu_charlie on alpha_yankee uniform_delta (cost=0.290..6.240 rows=8 width=12) (actual time=0.158..0.977 rows=7 loops=3,694)

  • Index Cond: (sierra = golf_yankee.quebec_seven)
9. 639.276 2,557.977 ↓ 5.6 362,100 1

Sort (cost=235,973.080..236,133.490 rows=64,165 width=828) (actual time=2,431.959..2,557.977 rows=362,100 loops=1)

  • Sort Key: tango.quebec_seven
  • Sort Method: external merge Disk: 124072kB
10. 330.153 1,918.701 ↓ 5.6 362,100 1

Hash Right Join (cost=49,354.930..207,382.160 rows=64,165 width=828) (actual time=445.394..1,918.701 rows=362,100 loops=1)

  • Hash Cond: (echo.kilo_charlie = tango.quebec_seven)
  • Filter: ((echo.romeo > 'xray_romeo'::timestamp without time zone) OR (oscar_sierra.romeo > 'xray_romeo'::timestamp without time zone) OR (tango.romeo > 'xray_romeo'::timestamp without time zone) OR (three.romeo > 'xray_romeo'::timestamp without time zone))
  • Rows Removed by Filter: 4480
11. 536.314 1,524.267 ↓ 1.0 1,021,009 1

Hash Left Join (cost=35,110.900..174,893.910 rows=980,889 width=20) (actual time=380.931..1,524.267 rows=1,021,009 loops=1)

  • Hash Cond: (echo.zulu_bravo = oscar_sierra.quebec_seven)
12. 607.664 607.664 ↓ 1.0 1,021,009 1

Seq Scan on echo (cost=0.000..114,866.670 rows=980,889 width=16) (actual time=0.095..607.664 rows=1,021,009 loops=1)

  • Filter: (yankee five_romeo_foxtrot NULL)
  • Rows Removed by Filter: 508840
13. 73.841 380.289 ↑ 1.0 424,754 1

Hash (cost=27,718.030..27,718.030 rows=425,270 width=12) (actual time=380.289..380.289 rows=424,754 loops=1)

  • Buckets: 131072 Batches: 8 Memory Usage: 3518kB
14. 306.448 306.448 ↑ 1.0 424,754 1

Seq Scan on oscar_sierra (cost=0.000..27,718.030 rows=425,270 width=12) (actual time=14.333..306.448 rows=424,754 loops=1)

  • Filter: (yankee five_romeo_foxtrot NULL)
  • Rows Removed by Filter: 9527
15. 4.652 64.281 ↑ 1.6 3,877 1

Hash (cost=13,484.280..13,484.280 rows=6,379 width=844) (actual time=64.281..64.281 rows=3,877 loops=1)

  • Buckets: 8192 Batches: 2 Memory Usage: 1631kB
16. 1.212 59.629 ↑ 1.6 3,877 1

Hash Join (cost=1,964.860..13,484.280 rows=6,379 width=844) (actual time=15.721..59.629 rows=3,877 loops=1)

  • Hash Cond: (tango.whiskey_whiskey = three.quebec_seven)
17. 1.863 57.316 ↑ 1.7 3,878 1

Hash Join (cost=1,750.420..13,181.800 rows=6,467 width=836) (actual time=14.599..57.316 rows=3,878 loops=1)

  • Hash Cond: (tango.quebec_seven = mike_alpha.kilo_charlie)
18. 41.227 41.227 ↑ 1.7 3,878 1

Seq Scan on tango (cost=0.000..11,341.980 rows=6,594 width=836) (actual time=0.143..41.227 rows=3,878 loops=1)

  • Filter: ((yankee five_romeo_foxtrot NULL) AND (papa_two five_romeo_foxtrot NOT NULL) AND (lima_five five_romeo_foxtrot NULL) AND (NOT five_alpha) AND ((two_charlie)::text <> 'whiskey_lima'::text) AND ((two_charlie)::text <> 'whiskey_lima'::text) AND ((((oscar_echo >= 'bravo_foxtrot'::timestamp without time zone) OR (oscar_echo five_romeo_foxtrot NULL) OR ((xray_three five_romeo_foxtrot NOT NULL) AND (xray_three > 'four'::timestamp without time zone))) AND ((two_charlie)::text <> 'delta'::text)) OR (((xray_three >= 'six_bravo'::timestamp without time zone) OR (xray_three five_romeo_foxtrot NULL)) AND ((two_charlie)::text = 'delta'::text))))
  • Rows Removed by Filter: 48504
19. 6.777 14.226 ↑ 1.0 51,352 1

Hash (cost=1,108.520..1,108.520 rows=51,352 width=4) (actual time=14.226..14.226 rows=51,352 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2318kB
20. 7.449 7.449 ↑ 1.0 51,352 1

Seq Scan on mike_alpha (cost=0.000..1,108.520 rows=51,352 width=4) (actual time=0.101..7.449 rows=51,352 loops=1)

21. 0.334 1.101 ↑ 1.0 2,389 1

Hash (cost=184.380..184.380 rows=2,405 width=12) (actual time=1.101..1.101 rows=2,389 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 144kB
22. 0.767 0.767 ↑ 1.0 2,389 1

Seq Scan on three (cost=0.000..184.380 rows=2,405 width=12) (actual time=0.005..0.767 rows=2,389 loops=1)

  • Filter: ((lima_five five_romeo_foxtrot NULL) AND five_romeo_zulu)
  • Rows Removed by Filter: 29
23.          

SubPlan (forGroup)

24. 93.062 1,207.357 ↑ 1.0 1 2,449

Aggregate (cost=2,177.370..2,177.390 rows=1 width=1) (actual time=0.493..0.493 rows=1 loops=2,449)

25. 23.440 1,114.295 ↑ 1.1 148 2,449

Nested Loop (cost=0.850..2,175.260 rows=169 width=20) (actual time=0.011..0.455 rows=148 loops=2,449)

26. 364.901 364.901 ↑ 1.1 148 2,449

Index Scan using alpha_lima on echo november (cost=0.430..775.210 rows=169 width=16) (actual time=0.006..0.149 rows=148 loops=2,449)

  • Index Cond: (kilo_charlie = tango.quebec_seven)
  • Filter: (yankee five_romeo_foxtrot NULL)
  • Rows Removed by Filter: 123
27. 725.954 725.954 ↑ 1.0 1 362,977

Index Scan using papa_three on oscar_sierra quebec_sierra (cost=0.420..8.270 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=362,977)

  • Index Cond: (quebec_seven = november.zulu_bravo)
28. 4.898 315.921 ↑ 1.0 1 2,449

Aggregate (cost=11.030..11.040 rows=1 width=32) (actual time=0.129..0.129 rows=1 loops=2,449)

29. 311.023 311.023 ↑ 1.0 2 2,449

Index Scan using victor on golf_uniform whiskey_romeo (cost=0.290..11.020 rows=2 width=4) (actual time=0.119..0.127 rows=2 loops=2,449)

  • Index Cond: (kilo_charlie = tango.quebec_seven)
30. 7.347 7.347 ↑ 1.0 1 2,449

Index Scan using alpha_three on three bravo_five (cost=0.280..8.300 rows=1 width=17) (actual time=0.003..0.003 rows=1 loops=2,449)

  • Index Cond: (tango.whiskey_whiskey = quebec_seven)
31. 2.449 2.449 ↑ 1.0 1 2,449

Index Scan using alpha_three on three six_mike (cost=0.280..8.300 rows=1 width=11) (actual time=0.001..0.001 rows=1 loops=2,449)

  • Index Cond: (tango.whiskey_whiskey = quebec_seven)
32. 19.592 19.592 ↑ 1.0 1 2,449

Index Scan using six_five on mike_alpha kilo_seven (cost=0.290..8.310 rows=1 width=32) (actual time=0.008..0.008 rows=1 loops=2,449)

  • Index Cond: (tango.quebec_seven = kilo_charlie)
33. 4.898 4.898 ↑ 1.0 1 2,449

Index Scan using alpha_three on three uniform_november (cost=0.280..8.300 rows=1 width=11) (actual time=0.001..0.002 rows=1 loops=2,449)

  • Index Cond: (tango.whiskey_whiskey = quebec_seven)
34. 4.898 4.898 ↑ 1.0 1 2,449

Index Scan using alpha_three on three mike_tango (cost=0.280..8.300 rows=1 width=17) (actual time=0.002..0.002 rows=1 loops=2,449)

  • Index Cond: (tango.whiskey_whiskey = quebec_seven)
35. 2.449 2.449 ↑ 1.0 1 2,449

Index Scan using alpha_three on three charlie (cost=0.280..8.300 rows=1 width=11) (actual time=0.001..0.001 rows=1 loops=2,449)

  • Index Cond: (tango.whiskey_whiskey = quebec_seven)