explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xzdfq

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

Sort (cost=21,257,388.75..21,257,437.79 rows=19,615 width=1,128) (actual rows= loops=)

  • Sort Key: (COALESCE(t_energy.te_source_file, t_quality.tq_source_file)), (COALESCE(t_energy.te_meter_id, t_quality.tq_meter_id)), (COALESCE(t_energy.te_frame_date, t_quality.tq_frame_date))
2.          

CTE t_quality

3. 0.000 0.000 ↓ 0.0

Subquery Scan on x (cost=10,623,739.55..10,625,905.14 rows=19,250 width=283) (actual rows= loops=)

  • Filter: (x.r < 2)
4. 0.000 0.000 ↓ 0.0

WindowAgg (cost=10,623,739.55..10,625,183.28 rows=57,749 width=287) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Sort (cost=10,623,739.55..10,623,883.92 rows=57,749 width=279) (actual rows= loops=)

  • Sort Key: t.meter_id, t.frame_date, t.num_ligne DESC
6. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.00..10,619,172.32 rows=57,749 width=279) (actual rows= loops=)

  • Workers Planned: 2
7. 0.000 0.000 ↓ 0.0

Result (cost=0.00..10,612,638.05 rows=24,063 width=279) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Append (cost=0.00..10,612,397.42 rows=24,063 width=279) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on kaifa_load_profiles_before_201901 t (cost=0.00..10.71 rows=1 width=492) (actual rows= loops=)

  • Filter: ((source_file = '/srv/acquisition/LP_20190513175000_26618_0-numerote.txt'::text) AND (type_ligne = 'QUALITY'::text))
10. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on kaifa_load_profiles_201901 t_1 (cost=0.00..1,177,257.94 rows=3,563 width=279) (actual rows= loops=)

  • Filter: ((source_file = '/srv/acquisition/LP_20190513175000_26618_0-numerote.txt'::text) AND (type_ligne = 'QUALITY'::text))
11. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on kaifa_load_profiles_201902 t_2 (cost=0.00..2,055,905.24 rows=3,869 width=278) (actual rows= loops=)

  • Filter: ((source_file = '/srv/acquisition/LP_20190513175000_26618_0-numerote.txt'::text) AND (type_ligne = 'QUALITY'::text))
12. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on kaifa_load_profiles_201903 t_3 (cost=0.00..2,922,415.23 rows=5,180 width=279) (actual rows= loops=)

  • Filter: ((source_file = '/srv/acquisition/LP_20190513175000_26618_0-numerote.txt'::text) AND (type_ligne = 'QUALITY'::text))
13. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on kaifa_load_profiles_201904 t_4 (cost=0.00..3,143,047.88 rows=5,749 width=279) (actual rows= loops=)

  • Filter: ((source_file = '/srv/acquisition/LP_20190513175000_26618_0-numerote.txt'::text) AND (type_ligne = 'QUALITY'::text))
14. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on kaifa_load_profiles_201905 t_5 (cost=0.00..1,313,749.71 rows=5,700 width=279) (actual rows= loops=)

  • Filter: ((source_file = '/srv/acquisition/LP_20190513175000_26618_0-numerote.txt'::text) AND (type_ligne = 'QUALITY'::text))
15. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on kaifa_load_profiles_201906 t_6 (cost=0.00..10.71 rows=1 width=492) (actual rows= loops=)

  • Filter: ((source_file = '/srv/acquisition/LP_20190513175000_26618_0-numerote.txt'::text) AND (type_ligne = 'QUALITY'::text))
16.          

CTE t_energy

17. 0.000 0.000 ↓ 0.0

Subquery Scan on x_1 (cost=10,623,943.62..10,626,150.27 rows=19,615 width=382) (actual rows= loops=)

  • Filter: (x_1.r < 2)
18. 0.000 0.000 ↓ 0.0

WindowAgg (cost=10,623,943.62..10,625,414.72 rows=58,844 width=386) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Sort (cost=10,623,943.62..10,624,090.73 rows=58,844 width=378) (actual rows= loops=)

  • Sort Key: t_7.meter_id, t_7.frame_date, t_7.num_ligne DESC
20. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.00..10,619,281.82 rows=58,844 width=378) (actual rows= loops=)

  • Workers Planned: 2
21. 0.000 0.000 ↓ 0.0

Result (cost=0.00..10,612,642.61 rows=24,519 width=378) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Append (cost=0.00..10,612,397.42 rows=24,519 width=378) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on kaifa_load_profiles_before_201901 t_7 (cost=0.00..10.71 rows=1 width=492) (actual rows= loops=)

  • Filter: ((source_file = '/srv/acquisition/LP_20190513175000_26618_0-numerote.txt'::text) AND (type_ligne = 'ENERGY'::text))
24. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on kaifa_load_profiles_201901 t_8 (cost=0.00..1,177,257.94 rows=3,500 width=378) (actual rows= loops=)

  • Filter: ((source_file = '/srv/acquisition/LP_20190513175000_26618_0-numerote.txt'::text) AND (type_ligne = 'ENERGY'::text))
25. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on kaifa_load_profiles_201902 t_9 (cost=0.00..2,055,905.24 rows=3,839 width=377) (actual rows= loops=)

  • Filter: ((source_file = '/srv/acquisition/LP_20190513175000_26618_0-numerote.txt'::text) AND (type_ligne = 'ENERGY'::text))
26. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on kaifa_load_profiles_201903 t_10 (cost=0.00..2,922,415.23 rows=5,390 width=378) (actual rows= loops=)

  • Filter: ((source_file = '/srv/acquisition/LP_20190513175000_26618_0-numerote.txt'::text) AND (type_ligne = 'ENERGY'::text))
27. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on kaifa_load_profiles_201904 t_11 (cost=0.00..3,143,047.88 rows=5,940 width=378) (actual rows= loops=)

  • Filter: ((source_file = '/srv/acquisition/LP_20190513175000_26618_0-numerote.txt'::text) AND (type_ligne = 'ENERGY'::text))
28. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on kaifa_load_profiles_201905 t_12 (cost=0.00..1,313,749.71 rows=5,848 width=378) (actual rows= loops=)

  • Filter: ((source_file = '/srv/acquisition/LP_20190513175000_26618_0-numerote.txt'::text) AND (type_ligne = 'ENERGY'::text))
29. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on kaifa_load_profiles_201906 t_13 (cost=0.00..10.71 rows=1 width=492) (actual rows= loops=)

  • Filter: ((source_file = '/srv/acquisition/LP_20190513175000_26618_0-numerote.txt'::text) AND (type_ligne = 'ENERGY'::text))
30. 0.000 0.000 ↓ 0.0

Merge Full Join (cost=3,545.70..3,934.82 rows=19,615 width=1,128) (actual rows= loops=)

  • Merge Cond: ((t_quality.tq_source_file = t_energy.te_source_file) AND (t_quality.tq_meter_id = t_energy.te_meter_id) AND (t_quality.tq_frame_date = t_energy.te_frame_date))
31. 0.000 0.000 ↓ 0.0

Sort (cost=1,754.88..1,803.01 rows=19,250 width=496) (actual rows= loops=)

  • Sort Key: t_quality.tq_source_file, t_quality.tq_meter_id, t_quality.tq_frame_date
32. 0.000 0.000 ↓ 0.0

CTE Scan on t_quality (cost=0.00..385.00 rows=19,250 width=496) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Sort (cost=1,790.82..1,839.85 rows=19,615 width=496) (actual rows= loops=)

  • Sort Key: t_energy.te_source_file, t_energy.te_meter_id, t_energy.te_frame_date
34. 0.000 0.000 ↓ 0.0

CTE Scan on t_energy (cost=0.00..392.30 rows=19,615 width=496) (actual rows= loops=)