explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WqCZ : Revenue

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

Gather Motion 8:1 (slice10; segments: 8) (cost=1,523,803,543.250..2,071,563,364.080 rows=5,359,892,560 width=569) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,523,803,543.250..2,071,563,364.080 rows=669,986,570 width=569) (actual rows= loops=)

  • Group By: p.gl_date, p.accounting_trx_id, ae.accounting_entity_key, ae.accounting_entity_id, ae.accounting_entity_type, ae.city, ae.state, ae.country_code, ae.country_name, ae.zip, g.gsv_type_code, g.gsv_type_name, g.gsv_category_name, g.gsv_subcategory_name, g.gl_account_id, g.product_code, g.gl_account_desc, p.is_estimated
3. 0.000 0.000 ↓ 0.0

Redistribute Motion 8:8 (slice9; segments: 8) (cost=386,455,540.810..734,848,557.210 rows=669,986,570 width=569) (actual rows= loops=)

  • Hash Key: p.gl_date, p.accounting_trx_id, ae.accounting_entity_key, ae.accounting_entity_id, ae.accounting_entity_type, ae.city, ae.state, ae.country_code, ae.country_name, ae.zip, g.gsv_type_code, g.gsv_type_name, g.gsv_category_name, g.gsv_subcategory_name, g.gl_account_id, g.product_code, g.gl_account_desc, p.is_estimated
4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=386,455,540.810..627,650,706.010 rows=669,986,570 width=569) (actual rows= loops=)

  • Group By: p.gl_date, p.accounting_trx_id, ae.accounting_entity_key, ae.accounting_entity_id, ae.accounting_entity_type, ae.city, ae.state, ae.country_code, ae.country_name, ae.zip, g.gsv_type_code, g.gsv_type_name, g.gsv_category_name, g.gsv_subcategory_name, g.gl_account_id, g.product_code, g.gl_account_desc, p.is_estimated
5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=6,624,183.670..91,661,450.000 rows=669,986,571 width=331) (actual rows= loops=)

  • Hash Cond: kilo_foxtrot.golf_hotel = "charlie"."?victor_juliet9?
6. 0.000 0.000 ↓ 0.0

Redistribute Motion 8:8 (slice2; segments: 8) (cost=49.680..4,288,542.990 rows=1,682,931 width=135) (actual rows= loops=)

  • Hash Key: p.accounting_entity_key
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=49.680..4,019,274.040 rows=1,682,931 width=135) (actual rows= loops=)

  • Hash Cond: kilo_foxtrot.yankee_yankee = kilo_tango.yankee_yankee::bigint
8. 0.000 0.000 ↓ 0.0

External Scan on payment_gsv_fact p (cost=0.000..3,266,924.720 rows=3,956,364 width=36) (actual rows= loops=)

  • Filter: hotel >= 'bravo_golf'::date AND hotel <= 'kilo_bravo'::date AND india::text <> 'two'::text
9. 0.000 0.000 ↓ 0.0

Hash (cost=26.880..26.880 rows=229 width=111) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Broadcast Motion 8:8 (slice1; segments: 8) (cost=0.000..26.880 rows=229 width=111) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

External Scan on gsv_type_dim g (cost=0.000..6.360 rows=29 width=111) (actual rows= loops=)

  • Filter: sierra_romeo
12. 0.000 0.000 ↓ 0.0

Hash (cost=6,111,833.140..6,111,833.140 rows=3,270,549 width=204) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Redistribute Motion 8:8 (slice8; segments: 8) (cost=1,530,356.040..6,111,833.140 rows=3,270,549 width=204) (actual rows= loops=)

  • Hash Key: "?column9?
14. 0.000 0.000 ↓ 0.0

Subquery Scan ae (cost=1,530,356.040..5,588,545.380 rows=3,270,549 width=204) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1,530,356.040..5,326,901.500 rows=3,270,549 width=120) (actual rows= loops=)

  • Hash Cond: delta.victor_mike = quebec.victor_mike
  • Join Filter: delta.golf_delta::text = 'echo'::text
16. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1,485,291.060..3,973,558.050 rows=3,270,549 width=98) (actual rows= loops=)

  • Hash Cond: delta.papa = juliet.papa
  • Join Filter: delta.golf_delta::text = 'zulu'::text
17. 0.000 0.000 ↓ 0.0

Redistribute Motion 8:8 (slice5; segments: 8) (cost=439,753.160..2,307,941.890 rows=3,270,549 width=76) (actual rows= loops=)

  • Hash Key: ae.freelancer_id
18. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=439,753.160..1,784,654.130 rows=3,270,549 width=76) (actual rows= loops=)

  • Hash Cond: delta.sierra_three = "charlie"."?victor_juliet7?
  • Join Filter: delta.golf_delta::text = 'victor_zulu'::text
19. 0.000 0.000 ↓ 0.0

Redistribute Motion 8:8 (slice3; segments: 8) (cost=0.000..866,694.640 rows=3,270,549 width=53) (actual rows= loops=)

  • Hash Key: ae.client_id
20. 0.000 0.000 ↓ 0.0

External Scan on accounting_entity_dim ae (cost=0.000..343,406.880 rows=3,270,549 width=53) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Hash (cost=345,516.040..345,516.040 rows=815,022 width=35) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Redistribute Motion 8:8 (slice4; segments: 8) (cost=0.000..345,516.040 rows=815,022 width=35) (actual rows= loops=)

  • Hash Key: "?column7?
23. 0.000 0.000 ↓ 0.0

External Scan on client_dim c (cost=0.000..215,112.640 rows=815,022 width=35) (actual rows= loops=)

  • Filter: yankee_kilo::text = 'yankee_golf'::text
24. 0.000 0.000 ↓ 0.0

Hash (cost=727,927.220..727,927.220 rows=2,746,897 width=38) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Redistribute Motion 8:8 (slice6; segments: 8) (cost=0.000..727,927.220 rows=2,746,897 width=38) (actual rows= loops=)

  • Hash Key: f.freelancer_id
26. 0.000 0.000 ↓ 0.0

External Scan on freelancer_dim f (cost=0.000..288,423.740 rows=2,746,897 width=38) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Hash (cost=23,349.220..23,349.220 rows=217,158 width=38) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Broadcast Motion 8:8 (slice7; segments: 8) (cost=0.000..23,349.220 rows=217,158 width=38) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

External Scan on agency_dim a (cost=0.000..3,805.040 rows=27,145 width=38) (actual rows= loops=)

  • Filter: yankee_kilo::text = 'bravo_three'::text