explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TqDv

Settings
# exclusive inclusive rows x rows loops node
1. 28.372 3,637.157 ↑ 727.7 3 1

Subquery Scan on papa_victor_six (cost=317,671.540..344,955.790 rows=2,183 width=264) (actual time=3,617.712..3,637.157 rows=3 loops=1)

  • Filter: (papa_victor_six.six_uniform = 8162)
  • Rows Removed by Filter: 435556
  • Planning time: 12.747 ms
  • Execution time: 3638.526 ms
2. 129.935 3,608.785 ↑ 1.0 435,559 1

Unique (cost=317,671.540..339,498.940 rows=436,548 width=264) (actual time=3,365.413..3,608.785 rows=435,559 loops=1)

3. 1,627.455 3,478.850 ↑ 1.0 435,559 1

Sort (cost=317,671.540..318,762.910 rows=436,548 width=264) (actual time=3,365.411..3,478.850 rows=435,559 loops=1)

  • Sort Key: ((november_november.six_uniform)::bigint), november_november.oscar_juliet_yankee, november_november.seven_papa, (NULL::bigint), ('seven_foxtrot'::text), november_november.kilo_hotel, six_oscar.oscar_juliet_xray, whiskey_five.foxtrot, november_november.yankee, november_november.six_golf, november_november.november_hotel, november_november.zulu_mike, november_november.quebec_five, november_november.uniform, november_november.two, november_november.quebec_seven, november_november.zulu_bravo, november_november.three, november_november.quebec_kilo
  • Sort Method: external merge Disk: 61408kB
4. 28.233 1,851.395 ↑ 1.0 435,559 1

Append (cost=139,327.280..169,340.200 rows=436,548 width=264) (actual time=1,527.825..1,851.395 rows=435,559 loops=1)

5. 88.503 1,781.275 ↓ 1.0 369,633 1

Result (cost=139,327.280..162,175.660 rows=365,574 width=232) (actual time=1,527.823..1,781.275 rows=369,633 loops=1)

6. 91.315 1,692.772 ↓ 1.0 369,633 1

Unique (cost=139,327.280..157,605.980 rows=365,574 width=228) (actual time=1,527.820..1,692.772 rows=369,633 loops=1)

7. 1,348.918 1,601.457 ↓ 1.0 369,633 1

Sort (cost=139,327.280..140,241.220 rows=365,574 width=228) (actual time=1,527.819..1,601.457 rows=369,633 loops=1)

  • Sort Key: november_november.six_uniform, november_november.oscar_juliet_yankee, november_november.seven_papa, (NULL::bigint), ('seven_foxtrot'::text), november_november.kilo_hotel, six_oscar.oscar_juliet_xray, whiskey_five.foxtrot, november_november.yankee, november_november.six_golf, november_november.november_hotel, november_november.zulu_mike, november_november.quebec_five, november_november.uniform, november_november.two, november_november.quebec_seven, november_november.zulu_bravo, november_november.three, november_november.quebec_kilo
  • Sort Method: external merge Disk: 47272kB
8. 22.834 252.539 ↓ 1.0 369,633 1

Append (cost=4,245.570..25,573.610 rows=365,574 width=228) (actual time=64.763..252.539 rows=369,633 loops=1)

9. 1.474 104.442 ↓ 2.1 7,698 1

Hash Left Join (cost=4,245.570..10,096.940 rows=3,726 width=274) (actual time=64.762..104.442 rows=7,698 loops=1)

  • Hash Cond: (six_oscar.oscar_juliet_xray = whiskey_five.quebec_seven)
10. 1.902 101.391 ↓ 2.1 7,698 1

Hash Left Join (cost=3,911.570..9,753.140 rows=3,726 width=230) (actual time=63.170..101.391 rows=7,698 loops=1)

  • Hash Cond: (november_november.zulu_bravo = six_oscar.quebec_seven)
11. 36.889 36.889 ↓ 2.1 7,698 1

Seq Scan on november_november (cost=0.000..5,831.790 rows=3,726 width=226) (actual time=0.282..36.889 rows=7,698 loops=1)

  • Filter: ((six_golf five_romeo NOT NULL) AND (november_hotel five_romeo NOT NULL) AND (quebec_kilo = ANY ('kilo_delta'::integer[])))
  • Rows Removed by Filter: 122365
12. 34.435 62.600 ↑ 1.0 72,470 1

Hash (cost=3,005.700..3,005.700 rows=72,470 width=8) (actual time=62.600..62.600 rows=72,470 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 3855kB
13. 28.165 28.165 ↑ 1.0 72,470 1

Seq Scan on six_oscar (cost=0.000..3,005.700 rows=72,470 width=8) (actual time=0.028..28.165 rows=72,470 loops=1)

14. 0.697 1.577 ↑ 1.0 5,600 1

Hash (cost=264.000..264.000 rows=5,600 width=8) (actual time=1.577..1.577 rows=5,600 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 283kB
15. 0.880 0.880 ↑ 1.0 5,600 1

Seq Scan on whiskey_five (cost=0.000..264.000 rows=5,600 width=8) (actual time=0.030..0.880 rows=5,600 loops=1)

16. 125.263 125.263 ↓ 1.0 361,935 1

Seq Scan on whiskey_romeo (cost=0.000..11,820.930 rows=361,848 width=210) (actual time=0.010..125.263 rows=361,935 loops=1)

  • Filter: ((six_golf five_romeo NOT NULL) AND (november_hotel five_romeo NOT NULL))
  • Rows Removed by Filter: 58
17. 25.326 41.887 ↑ 1.1 65,926 1

Hash Join (cost=2,292.700..6,454.800 rows=70,974 width=303) (actual time=4.214..41.887 rows=65,926 loops=1)

  • Hash Cond: (delta_november1.oscar_juliet_xray = delta_five1.quebec_seven)
18. 12.375 12.375 ↓ 1.0 72,123 1

Seq Scan on six_oscar lima (cost=0.000..3,005.700 rows=71,795 width=171) (actual time=0.012..12.375 rows=72,123 loops=1)

  • Filter: ((six_golf five_romeo NOT NULL) AND (november_hotel five_romeo NOT NULL))
  • Rows Removed by Filter: 347
19. 0.767 4.186 ↑ 1.0 5,425 1

Hash (cost=2,223.500..2,223.500 rows=5,536 width=20) (actual time=4.186..4.186 rows=5,425 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 297kB
20. 0.748 3.419 ↑ 1.0 5,425 1

Hash Left Join (cost=1,872.910..2,223.500 rows=5,536 width=20) (actual time=0.671..3.419 rows=5,425 loops=1)

  • Hash Cond: (delta_five1.juliet = xray_kilo.quebec_seven)
  • Join Filter: ((delta_five1.xray_sierra)::text = 'papa_victor_delta'::text)
21. 0.799 2.666 ↑ 1.0 5,425 1

Hash Anti Join (cost=1,844.910..2,180.970 rows=5,536 width=21) (actual time=0.661..2.666 rows=5,425 loops=1)

  • Hash Cond: (delta_five1.quebec_seven = delta_november2.oscar_juliet_xray)
22. 1.238 1.238 ↑ 1.0 5,600 1

Seq Scan on whiskey_five five_juliet (cost=0.000..264.000 rows=5,600 width=21) (actual time=0.028..1.238 rows=5,600 loops=1)

23. 0.028 0.629 ↓ 3.2 203 1

Hash (cost=1,844.110..1,844.110 rows=64 width=4) (actual time=0.628..0.629 rows=203 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
24. 0.009 0.601 ↓ 3.2 203 1

Nested Loop (cost=10.090..1,844.110 rows=64 width=4) (actual time=0.053..0.601 rows=203 loops=1)

25. 0.159 0.186 ↓ 1.1 203 1

Bitmap Heap Scan on november_november echo (cost=9.800..604.930 rows=178 width=4) (actual time=0.044..0.186 rows=203 loops=1)

  • Recheck Cond: ((two)::text = 'zulu_yankee'::text)
  • Heap Blocks: exact=153
26. 0.027 0.027 ↓ 1.1 203 1

Bitmap Index Scan on alpha (cost=0.000..9.750 rows=178 width=0) (actual time=0.027..0.027 rows=203 loops=1)

  • Index Cond: ((two)::text = 'zulu_yankee'::text)
27. 0.406 0.406 ↑ 1.0 1 203

Index Scan using papa_foxtrot on six_oscar india (cost=0.290..6.960 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=203)

  • Index Cond: (quebec_seven = six_sierra1.zulu_bravo)
28. 0.002 0.005 ↑ 800.0 1 1

Hash (cost=18.000..18.000 rows=800 width=16) (actual time=0.005..0.005 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
29. 0.003 0.003 ↑ 800.0 1 1

Seq Scan on xray_kilo (cost=0.000..18.000 rows=800 width=16) (actual time=0.003..0.003 rows=1 loops=1)