explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gpO3

Settings
# exclusive inclusive rows x rows loops node
1. 28.111 12,058.579 ↑ 7.3 820 1

HashAggregate (cost=3,816.420..3,876.680 rows=6,026 width=143) (actual time=12,057.999..12,058.579 rows=820 loops=1)

  • Group Key: charlie.quebec, charlie.november, charlie.zulu_mike, charlie.lima_golf, charlie.seven_papa_alpha, charlie.romeo_hotel, charlie.seven_hotel, charlie.lima_juliet, charlie.echo_lima, charlie.five_tango, charlie.juliet_six, charlie.alpha, charlie.juliet_delta, charlie.uniform
2. 11,788.888 12,030.468 ↓ 1.9 13,454 1

Hash Left Join (cost=2,671.870..3,565.890 rows=7,158 width=143) (actual time=320.001..12,030.468 rows=13,454 loops=1)

  • Hash Cond: (echo_three.xray = seven_papa_oscar.victor_kilo)
  • Filter: (((lima_november.quebec = 245) AND delta.foxtrot_oscar AND (delta.foxtrot_three <= 'two'::date) AND (delta.lima_romeo >= 'two'::date)) OR (seven_papa_oscar.victor_kilo = ANY ('three'::bigint[])) OR (charlie.quebec five_romeo NULL))
  • Rows Removed by Filter: 380161
3. 171.737 218.218 ↓ 6.8 393,615 1

Hash Left Join (cost=1,349.650..2,079.880 rows=58,210 width=160) (actual time=24.043..218.218 rows=393,615 loops=1)

  • Hash Cond: (kilo.hotel = delta.quebec)
4. 20.004 42.074 ↓ 3.1 24,882 1

Hash Right Join (cost=1,110.350..1,319.700 rows=8,139 width=151) (actual time=19.618..42.074 rows=24,882 loops=1)

  • Hash Cond: (echo_three.victor_papa = charlie.quebec)
5. 2.488 2.488 ↑ 1.0 6,033 1

Seq Scan on echo_three (cost=0.000..105.330 rows=6,033 width=8) (actual time=0.012..2.488 rows=6,033 loops=1)

6. 4.294 19.582 ↓ 1.3 5,461 1

Hash (cost=1,059.540..1,059.540 rows=4,065 width=147) (actual time=19.582..19.582 rows=5,461 loops=1)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 816kB
7. 2.328 15.288 ↓ 1.3 5,461 1

Hash Left Join (cost=216.360..1,059.540 rows=4,065 width=147) (actual time=4.453..15.288 rows=5,461 loops=1)

  • Hash Cond: (five_yankee.romeo_quebec = kilo.quebec)
8. 4.998 12.030 ↓ 1.3 5,461 1

Hash Right Join (cost=132.790..965.280 rows=4,065 width=147) (actual time=3.516..12.030 rows=5,461 loops=1)

  • Hash Cond: (five_yankee.victor_papa = charlie.quebec)
9. 3.551 3.551 ↑ 1.0 18,889 1

Seq Scan on five_yankee (cost=0.000..782.890 rows=18,889 width=8) (actual time=0.008..3.551 rows=18,889 loops=1)

10. 2.076 3.481 ↑ 1.0 3,013 1

Hash (cost=95.130..95.130 rows=3,013 width=143) (actual time=3.481..3.481 rows=3,013 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 460kB
11. 1.405 1.405 ↑ 1.0 3,013 1

Seq Scan on charlie (cost=0.000..95.130 rows=3,013 width=143) (actual time=0.012..1.405 rows=3,013 loops=1)

12. 0.442 0.930 ↑ 1.0 1,492 1

Hash (cost=64.920..64.920 rows=1,492 width=8) (actual time=0.930..0.930 rows=1,492 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 75kB
13. 0.488 0.488 ↑ 1.0 1,492 1

Seq Scan on kilo (cost=0.000..64.920 rows=1,492 width=8) (actual time=0.006..0.488 rows=1,492 loops=1)

14. 0.306 4.407 ↓ 1.2 875 1

Hash (cost=230.530..230.530 rows=701 width=17) (actual time=4.407..4.407 rows=875 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 53kB
15. 0.405 4.101 ↓ 1.2 875 1

Hash Left Join (cost=203.700..230.530 rows=701 width=17) (actual time=3.140..4.101 rows=875 loops=1)

  • Hash Cond: (oscar.zulu_lima = lima_november.quebec)
16. 0.465 0.694 ↓ 1.2 875 1

Hash Right Join (cost=4.540..29.540 rows=701 width=17) (actual time=0.111..0.694 rows=875 loops=1)

  • Hash Cond: (oscar.hotel = delta.quebec)
17. 0.138 0.138 ↑ 1.0 944 1

Seq Scan on oscar (cost=0.000..14.440 rows=944 width=8) (actual time=0.009..0.138 rows=944 loops=1)

18. 0.039 0.091 ↑ 1.0 98 1

Hash (cost=3.320..3.320 rows=98 width=13) (actual time=0.091..0.091 rows=98 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
19. 0.052 0.052 ↑ 1.0 98 1

Seq Scan on delta (cost=0.000..3.320 rows=98 width=13) (actual time=0.010..0.052 rows=98 loops=1)

  • Filter: foxtrot_oscar
  • Rows Removed by Filter: 34
20. 0.778 3.002 ↑ 1.0 2,848 1

Hash (cost=162.730..162.730 rows=2,914 width=4) (actual time=3.002..3.002 rows=2,848 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 133kB
21. 2.224 2.224 ↑ 1.0 2,848 1

Seq Scan on lima_november (cost=0.000..162.730 rows=2,914 width=4) (actual time=0.007..2.224 rows=2,848 loops=1)

  • Filter: (NOT juliet_delta)
  • Rows Removed by Filter: 58
22. 9.999 23.362 ↑ 1.0 35,555 1

Hash (cost=877.100..877.100 rows=35,610 width=8) (actual time=23.362..23.362 rows=35,555 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 1901kB
23. 13.363 13.363 ↑ 1.0 35,555 1

Seq Scan on seven_papa_oscar (cost=0.000..877.100 rows=35,610 width=8) (actual time=0.011..13.363 rows=35,555 loops=1)