explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KQg3

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 16,459.586 ↓ 0.0 0 1

Insert on bitelco.f_campaign_transition_data_science (cost=165,085.58..276,993.69 rows=111,528 width=7,681) (actual time=16,459.586..16,459.586 rows=0 loops=1)

2. 0.002 16,459.584 ↓ 0.0 0 1

Subquery Scan on *SELECT* (cost=165,085.58..276,993.69 rows=111,528 width=7,681) (actual time=16,459.584..16,459.584 rows=0 loops=1)

3. 0.002 16,459.582 ↓ 0.0 0 1

GroupAggregate (cost=165,085.58..255,524.55 rows=111,528 width=2,261) (actual time=16,459.582..16,459.582 rows=0 loops=1)

4. 612.736 16,459.580 ↓ 0.0 0 1

Merge Anti Join (cost=165,085.58..180,893.49 rows=214,520 width=195) (actual time=16,459.580..16,459.580 rows=0 loops=1)

5. 4,180.281 4,534.606 ↑ 1.0 221,440 1

Sort (cost=31,291.46..31,845.06 rows=221,440 width=195) (actual time=4,499.847..4,534.606 rows=221,440 loops=1)

6. 354.325 354.325 ↑ 1.0 221,440 1

Seq Scan on bitelco.part_f_campaign_transition_detail (cost=0.00..11,631.40 rows=221,440 width=195) (actual time=0.019..354.325 rows=221,440 loops=1)

7. 10,730.208 11,312.238 ↑ 1.1 785,346 1

Sort (cost=133,794.12..135,875.17 rows=832,420 width=65) (actual time=11,175.542..11,312.238 rows=785,346 loops=1)

8. 96.004 582.030 ↑ 1.0 831,562 1

Append (cost=0.00..51,938.30 rows=832,420 width=65) (actual time=0.141..582.030 rows=831,562 loops=1)

9. 0.022 0.022 ↓ 0.0 0 1

Seq Scan on bitelco.f_campaign_transition_data_science_p201804 f (cost=0.00..10.10 rows=10 width=494) (actual time=0.022..0.022 rows=0 loops=1)

10. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on bitelco.f_campaign_transition_data_science_p201805 f_1 (cost=0.00..10.10 rows=10 width=494) (actual time=0.005..0.005 rows=0 loops=1)

11. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on bitelco.f_campaign_transition_data_science_p201806 f_2 (cost=0.00..10.10 rows=10 width=494) (actual time=0.004..0.004 rows=0 loops=1)

12. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on bitelco.f_campaign_transition_data_science_p201807 f_3 (cost=0.00..10.10 rows=10 width=494) (actual time=0.005..0.005 rows=0 loops=1)

13. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on bitelco.f_campaign_transition_data_science_p201808 f_4 (cost=0.00..10.10 rows=10 width=494) (actual time=0.004..0.004 rows=0 loops=1)

14. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on bitelco.f_campaign_transition_data_science_p201809 f_5 (cost=0.00..10.10 rows=10 width=494) (actual time=0.004..0.004 rows=0 loops=1)

15. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on bitelco.f_campaign_transition_data_science_p201810 f_6 (cost=0.00..10.10 rows=10 width=494) (actual time=0.004..0.004 rows=0 loops=1)

16. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on bitelco.f_campaign_transition_data_science_p201811 f_7 (cost=0.00..10.10 rows=10 width=494) (actual time=0.004..0.004 rows=0 loops=1)

17. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on bitelco.f_campaign_transition_data_science_p201812 f_8 (cost=0.00..10.10 rows=10 width=494) (actual time=0.004..0.004 rows=0 loops=1)

18. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on bitelco.f_campaign_transition_data_science_p201901 f_9 (cost=0.00..10.10 rows=10 width=494) (actual time=0.005..0.005 rows=0 loops=1)

19. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on bitelco.f_campaign_transition_data_science_p201902 f_10 (cost=0.00..10.10 rows=10 width=494) (actual time=0.004..0.004 rows=0 loops=1)

20. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on bitelco.f_campaign_transition_data_science_p201903 f_11 (cost=0.00..10.10 rows=10 width=494) (actual time=0.004..0.004 rows=0 loops=1)

21. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on bitelco.f_campaign_transition_data_science_p201904 f_12 (cost=0.00..10.10 rows=10 width=494) (actual time=0.004..0.004 rows=0 loops=1)

22. 485.530 485.530 ↑ 1.0 830,765 1

Seq Scan on bitelco.f_campaign_transition_data_science_p201905 f_13 (cost=0.00..47,567.73 rows=831,473 width=65) (actual time=0.057..485.530 rows=830,765 loops=1)

23. 0.412 0.412 ↑ 1.0 797 1

Seq Scan on bitelco.f_campaign_transition_data_science_p201906 f_14 (cost=0.00..56.97 rows=797 width=64) (actual time=0.016..0.412 rows=797 loops=1)

24. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on bitelco.f_campaign_transition_data_science_p201907 f_15 (cost=0.00..10.10 rows=10 width=494) (actual time=0.007..0.007 rows=0 loops=1)

25. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on bitelco.f_campaign_transition_data_science_p201908 f_16 (cost=0.00..10.10 rows=10 width=494) (actual time=0.004..0.004 rows=0 loops=1)