explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V0wE

Settings
# exclusive inclusive rows x rows loops node
1. 0.327 78,917.381 ↑ 146,242.1 230 1

Merge Left Join (cost=451,053.930..1,045,118.670 rows=33,635,679 width=5) (actual time=78,915.912..78,917.381 rows=230 loops=1)

  • Merge Cond: ((seven_three(six_bravo.papa, six_bravo.alpha)::three) = (seven_three(victor_xray.papa, victor_xray.alpha)::three))
2. 49,384.756 49,384.756 ↑ 138.7 230 1

Merge Left Join (cost=257.160..872.920 rows=31,900 width=32) (actual time=49,383.739..49,384.756 rows=230 loops=1)

3. 0.000 29,532.298 ↑ 857.2 246 1

Materialize (cost=450,796.770..456,068.820 rows=210,882 width=40) (actual time=29,532.155..29,532.298 rows=246 loops=1)

  • Merge Cond: ((seven_three(six_bravo.papa, six_bravo.alpha)::three) = quebec_kilo.quebec_seven)
4. 29,532.268 29,532.268 ↑ 857.2 246 1

Unique (cost=450,796.770..453,432.800 rows=210,882 width=64) (actual time=29,532.153..29,532.268 rows=246 loops=1)

5. 7,683.351 7,683.351 ↑ 4.4 229 1

Sort (cost=59.830..62.330 rows=1,000 width=32) (actual time=7,683.312..7,683.351 rows=229 loops=1)

6. 0.000 41,701.126 ↑ 27.7 230 1

Merge Left Join (cost=197.330..318.640 rows=6,380 width=32) (actual time=41,700.420..41,701.126 rows=230 loops=1)

  • Sort Method: external sort Disk: 6,968kB
  • Sort Key: quebec_kilo.quebec_seven
  • Merge Cond: ((seven_three(six_bravo.papa, six_bravo.alpha)::three) = sierra.quebec_seven)
7. 1.550 1.550 ↑ 5.5 230 1

Unique (cost=137.500..147.160 rows=1,276 width=37) (actual time=0.992..1.550 rows=230 loops=1)

8. 41,699.427 41,699.427 ↑ 20.4 49 1

Sort (cost=59.830..62.330 rows=1,000 width=32) (actual time=41,699.420..41,699.427 rows=49 loops=1)

9. 29,532.184 29,532.184 ↑ 857.2 246 1

Sort (cost=450,796.770..451,323.980 rows=210,882 width=64) (actual time=29,532.151..29,532.184 rows=246 loops=1)

10. 0.000 5,925.207 ↓ 165.8 165,801 1

Function Scan on charlie quebec_kilo (cost=0.000..10.000 rows=1,000 width=32) (actual time=5,898.115..5,925.207 rows=165,801 loops=1)

  • Sort Method: external sort Disk: 2,408kB
  • Sort Method: external sort Disk: 12,360kB
  • Sort Key: sierra.quebec_seven
  • Sort Key: (seven_three(victor_xray.papa, victor_xray.alpha)::three), (five_two(1) five_xray (WHERE (((victor_xray.uniform)::text = 'victor_golf'::text) AND (victor_xray.oscar five_romeo NULL)))), (five_two(1) five_xray (WHERE (((victor_xray.uniform)::text = 'juliet'::text) AND (victor_xray.oscar five_romeo NULL)))), (five_two(1) five_xray (WHERE (((victor_xray.uniform)::text = 'yankee'::text) AND (victor_xray.oscar five_romeo NULL))))
11. 1.082 1.082 ↑ 1.0 1,227 1

Sort (cost=137.500..140.720 rows=1,288 width=37) (actual time=0.990..1.082 rows=1,227 loops=1)

12. 28,021.414 28,021.414 ↑ 1.2 170,728 1

GroupAggregate (cost=377,719.110..427,276.490 rows=210,882 width=64) (actual time=27,595.470..28,021.414 rows=170,728 loops=1)

13. 13,371.450 41,180.943 ↓ 57.3 57,288 1

Function Scan on charlie sierra (cost=0.000..10.000 rows=1,000 width=32) (actual time=41,173.174..41,180.943 rows=57,288 loops=1)

  • Sort Method: quicksort Memory: 144kB
  • Sort Key: (seven_three(six_bravo.papa, six_bravo.alpha)::three), six_bravo.six_whiskey
  • Group Key: victor_xray.papa, victor_xray.alpha
14. 27,809.076 27,809.076 ↑ 4.1 519,939 1

Sort (cost=377,719.110..382,991.170 rows=2,108,825 width=30) (actual time=27,594.043..27,809.076 rows=519,939 loops=1)

15. 0.000 0.417 ↑ 1.0 1,227 1

Index Only Scan using seven_seven on six_bravo (cost=0.420..70.960 rows=1,288 width=37) (actual time=0.021..0.417 rows=1,227 loops=1)

  • Sort Method: external merge Disk: 16,512kB
  • Sort Key: victor_xray.papa, victor_xray.alpha
  • Index Cond: (papa = 1)
  • Heap Fetches: 141
16. 27,184.790 27,184.790 ↑ 4.1 519,939 1

Seq Scan on victor_xray (cost=0.000..94,219.250 rows=2,108,825 width=30) (actual time=11.139..27,184.790 rows=519,939 loops=1)

Execution time : 78,927.349 ms