explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pvt80 : Optimization for: plan #fhwJ

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Window (cost=6,053,615.360..163,161,083,789.670 rows=10,427 width=1,090) (actual rows= loops=)

  • Order By: t1.uv_source_system
2. 0.000 0.000 ↓ 0.0

Gather Motion 144:1 (slice4; segments: 144) (cost=6,053,615.360..6,053,849.960 rows=10,427 width=1,090) (actual rows= loops=)

  • Merge Key: t1.uv_source_system
3. 0.000 0.000 ↓ 0.0

Sort (cost=6,053,615.360..6,053,641.430 rows=73 width=1,090) (actual rows= loops=)

  • Sort Key: romeo1.xray_mike
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=26,780.000..6,052,919.500 rows=73 width=1,090) (actual rows= loops=)

  • Hash Cond: romeo1.bravo::text = romeo.zulu::text
5. 0.000 0.000 ↓ 0.0

Seq Scan on papa_quebec four (cost=0.000..5,752,972.000 rows=748,083 width=292) (actual rows= loops=)

  • Filter: xray_mike::text <> 'three'::text
6. 0.000 0.000 ↓ 0.0

Hash (cost=12,380.000..12,380.000 rows=8,000 width=798) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Broadcast Motion 144:144 (slice3; segments: 144) (cost=0.000..12,380.000 rows=8,000 width=798) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Append (cost=0.000..780.000 rows=56 width=799) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on xray_juliet romeo (cost=0.000..116.000 rows=12 width=183) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on papa_bravo romeo (cost=0.000..104.000 rows=3 width=3,207) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on victor romeo (cost=0.000..116.000 rows=12 width=184) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on two romeo (cost=0.000..116.000 rows=12 width=178) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on lima romeo (cost=0.000..112.000 rows=9 width=1,244) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on tango_echo romeo (cost=0.000..104.000 rows=3 width=3,207) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on kilo_victor romeo (cost=0.000..112.000 rows=9 width=1,212) (actual rows= loops=)

16.          

SubPlan (forWindow)

17. 0.000 0.000 ↓ 0.0

Result (cost=7,593,986.400..7,593,986.410 rows=1 width=0) (actual rows= loops=)

  • Filter: six_six.six_lima000215tango_xray.yankee = $0
18. 0.000 0.000 ↓ 0.0

Materialize (cost=7,593,986.400..7,593,986.410 rows=1 width=0) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Gather Motion 144:1 (slice2; segments: 144) (cost=0.000..7,593,986.400 rows=1 width=0) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Seq Scan on papa_quebec (cost=0.000..7,593,986.400 rows=1 width=0) (actual rows= loops=)

  • Filter: uniform five NOT NULL AND bravo five NOT NULL AND xray_mike::text = 'three'::text AND (hotel = 1::numeric OR golf_uniform = 1::numeric OR seven = 1::numeric)
21. 0.000 0.000 ↓ 0.0

Result (cost=8,054,240.000..8,054,240.010 rows=1 width=0) (actual rows= loops=)

  • Filter: six_six.six_lima000215tango_xray.yankee = $0
22. 0.000 0.000 ↓ 0.0

Materialize (cost=8,054,240.000..8,054,240.010 rows=1 width=0) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Gather Motion 144:1 (slice1; segments: 144) (cost=0.000..8,054,240.000 rows=1 width=0) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Seq Scan on papa_quebec (cost=0.000..8,054,240.000 rows=1 width=0) (actual rows= loops=)

  • Filter: xray_seven five NOT NULL AND bravo five NOT NULL AND xray_mike::text = 'three'::text AND mike = 0::numeric AND (november = 1::numeric OR kilo_mike = 1::numeric OR golf_alpha = 1::numeric)