explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jfP

Settings
# exclusive inclusive rows x rows loops node
1. 1,002.434 6,465.581 ↓ 1.4 1,397,392 1

WindowAgg (cost=98,438.66..284,216.45 rows=997,724 width=1,000) (actual time=1,075.737..6,465.581 rows=1,397,392 loops=1)

2. 391.012 5,463.147 ↓ 1.4 1,397,392 1

Hash Left Join (cost=98,438.66..271,744.90 rows=997,724 width=952) (actual time=1,075.731..5,463.147 rows=1,397,392 loops=1)

  • Hash Cond: (x4.party_id = x14.party_id)
3. 509.038 5,068.187 ↓ 1.4 1,397,392 1

Hash Join (cost=97,920.71..267,066.99 rows=997,724 width=958) (actual time=1,071.764..5,068.187 rows=1,397,392 loops=1)

  • Hash Cond: (x5.sale_cnl_id = x7.sale_cnl_id)
4. 544.923 4,559.140 ↓ 1.4 1,397,392 1

Hash Join (cost=97,919.56..262,861.14 rows=997,724 width=963) (actual time=1,071.750..4,559.140 rows=1,397,392 loops=1)

  • Hash Cond: (x1.bsn_inter_spec_id = x6.bsn_inter_spec_id)
5. 540.787 4,013.991 ↓ 1.4 1,397,392 1

Hash Join (cost=97,899.25..260,197.58 rows=997,724 width=931) (actual time=1,071.520..4,013.991 rows=1,397,392 loops=1)

  • Hash Cond: (x2.bsn_inter_feed_config_id = x9.bsn_inter_feed_config_id)
6. 860.039 3,473.175 ↓ 1.4 698,696 1

Gather (cost=97,897.40..247,724.17 rows=498,862 width=364) (actual time=1,071.483..3,473.175 rows=698,696 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
7. 88.623 2,613.136 ↓ 1.1 232,899 3 / 3

Hash Left Join (cost=96,897.40..196,837.97 rows=207,859 width=364) (actual time=1,068.150..2,613.136 rows=232,899 loops=3)

  • Hash Cond: (co.ord_st_id = os.ord_st_id)
  • Filter: (((os.shrt_code)::text <> ALL ('{QUOTE,REJECTED}'::text[])) OR (os.ord_st_id IS NULL))
  • Rows Removed by Filter: 1140
8. 153.288 2,524.492 ↓ 1.0 234,039 3 / 3

Hash Join (cost=96,895.83..196,120.20 rows=225,934 width=369) (actual time=1,068.091..2,524.492 rows=234,039 loops=3)

  • Hash Cond: (x1.bsn_inter_spec_id = x2.bsn_inter_spec_id)
9. 569.789 2,371.178 ↑ 1.1 417,070 3 / 3

Hash Left Join (cost=96,894.36..192,209.48 rows=439,977 width=131) (actual time=1,068.013..2,371.178 rows=417,070 loops=3)

  • Hash Cond: (x1.bsn_inter_id = co.bsn_inter_id)
10. 317.056 1,135.288 ↑ 1.1 417,070 3 / 3

Hash Join (cost=34,395.27..102,593.97 rows=439,977 width=107) (actual time=401.284..1,135.288 rows=417,070 loops=3)

  • Hash Cond: (x1.cuser = x5.user_id)
11. 299.866 722.567 ↑ 1.3 422,694 3 / 3

Hash Join (cost=23,706.66..75,626.13 rows=529,986 width=73) (actual time=305.380..722.567 rows=422,694 loops=3)

  • Hash Cond: (x1.cust_id = x3.cust_id)
12. 117.613 117.613 ↑ 1.2 600,261 3 / 3

Parallel Seq Scan on bsn_inter x1 (cost=0.00..27,978.99 rows=750,299 width=52) (actual time=0.004..117.613 rows=600,261 loops=3)

13. 52.040 305.088 ↓ 1.0 171,217 3 / 3

Hash (cost=20,395.50..20,395.50 rows=171,213 width=27) (actual time=305.088..305.088 rows=171,217 loops=3)

  • Buckets: 65536 Batches: 4 Memory Usage: 3114kB
14. 110.411 253.048 ↓ 1.0 171,217 3 / 3

Hash Join (cost=12,586.92..20,395.50 rows=171,213 width=27) (actual time=120.861..253.048 rows=171,217 loops=3)

  • Hash Cond: (x3.party_id = x4.party_id)
15. 22.148 22.148 ↓ 1.0 171,217 3 / 3

Seq Scan on cust x3 (cost=0.00..4,037.13 rows=171,213 width=12) (actual time=0.011..22.148 rows=171,217 loops=3)

16. 75.197 120.489 ↓ 1.0 281,157 3 / 3

Hash (cost=7,424.52..7,424.52 rows=281,152 width=21) (actual time=120.489..120.489 rows=281,157 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 2413kB
17. 45.292 45.292 ↓ 1.0 281,157 3 / 3

Seq Scan on party x4 (cost=0.00..7,424.52 rows=281,152 width=21) (actual time=0.011..45.292 rows=281,157 loops=3)

18. 53.537 95.665 ↓ 1.0 183,009 3 / 3

Hash (cost=6,971.05..6,971.05 rows=183,005 width=40) (actual time=95.665..95.665 rows=183,009 loops=3)

  • Buckets: 65536 Batches: 4 Memory Usage: 3531kB
19. 42.128 42.128 ↓ 1.0 183,009 3 / 3

Seq Scan on apl_user x5 (cost=0.00..6,971.05 rows=183,005 width=40) (actual time=0.006..42.128 rows=183,009 loops=3)

20. 319.441 666.101 ↓ 1.0 1,169,954 3 / 3

Hash (cost=39,877.15..39,877.15 rows=1,169,915 width=30) (actual time=666.101..666.101 rows=1,169,954 loops=3)

  • Buckets: 65536 Batches: 32 Memory Usage: 2675kB
21. 346.660 346.660 ↓ 1.0 1,169,954 3 / 3

Seq Scan on cust_ord co (cost=0.00..39,877.15 rows=1,169,915 width=30) (actual time=0.010..346.660 rows=1,169,954 loops=3)

22. 0.009 0.026 ↑ 1.0 19 3 / 3

Hash (cost=1.24..1.24 rows=19 width=238) (actual time=0.026..0.026 rows=19 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
23. 0.017 0.017 ↑ 1.0 19 3 / 3

Seq Scan on bsn_inter_feed_config x2 (cost=0.00..1.24 rows=19 width=238) (actual time=0.011..0.017 rows=19 loops=3)

  • Filter: (is_actv = '1'::numeric)
24. 0.010 0.021 ↑ 1.0 25 3 / 3

Hash (cost=1.25..1.25 rows=25 width=14) (actual time=0.021..0.021 rows=25 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
25. 0.011 0.011 ↑ 1.0 25 3 / 3

Seq Scan on ord_st os (cost=0.00..1.25 rows=25 width=14) (actual time=0.008..0.011 rows=25 loops=3)

26. 0.014 0.029 ↑ 1.0 38 1

Hash (cost=1.38..1.38 rows=38 width=577) (actual time=0.029..0.029 rows=38 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
27. 0.015 0.015 ↑ 1.0 38 1

Seq Scan on bsn_inter_feed_config_lang x9 (cost=0.00..1.38 rows=38 width=577) (actual time=0.004..0.015 rows=38 loops=1)

28. 0.124 0.226 ↑ 1.0 458 1

Hash (cost=14.58..14.58 rows=458 width=42) (actual time=0.226..0.226 rows=458 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
29. 0.102 0.102 ↑ 1.0 458 1

Seq Scan on bsn_inter_spec x6 (cost=0.00..14.58 rows=458 width=42) (actual time=0.003..0.102 rows=458 loops=1)

30. 0.003 0.009 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=5) (actual time=0.009..0.009 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
31. 0.006 0.006 ↑ 1.0 7 1

Seq Scan on sale_cnl x7 (cost=0.00..1.07 rows=7 width=5) (actual time=0.004..0.006 rows=7 loops=1)

32. 2.047 3.948 ↑ 1.3 11,793 1

Hash (cost=326.31..326.31 rows=15,331 width=6) (actual time=3.948..3.948 rows=11,793 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 578kB
33. 1.901 1.901 ↑ 1.0 15,331 1

Seq Scan on emp x14 (cost=0.00..326.31 rows=15,331 width=6) (actual time=0.003..1.901 rows=15,331 loops=1)

Planning time : 3.797 ms
Execution time : 6,541.001 ms