explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aohI

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 4,205.785 ↓ 155.0 155 1

HashAggregate (cost=5,851.95..5,851.97 rows=1 width=276) (actual time=4,205.723..4,205.785 rows=155 loops=1)

  • Group Key: smam1.product_category_description_, smam1.abc_category_
2.          

Initplan (forHashAggregate)

3. 83.333 4,165.588 ↑ 1.0 1 1

Aggregate (cost=3,624.59..3,624.60 rows=1 width=36) (actual time=4,165.588..4,165.588 rows=1 loops=1)

4. 2,841.822 4,082.255 ↓ 782,445.0 782,445 1

Nested Loop (cost=0.00..3,624.58 rows=1 width=36) (actual time=21.248..4,082.255 rows=782,445 loops=1)

  • Join Filter: ((smam3.product_category_)::text = (smam2.product_category_)::text)
  • Rows Removed by Join Filter: 21846604
5. 27.398 27.398 ↓ 1,585.7 4,757 1

Foreign Scan on sp_mi_abc_month smam3 (cost=0.00..1,800.72 rows=3 width=224) (actual time=9.999..27.398 rows=4,757 loops=1)

  • Filter: (((dealer_code_)::text = 'UA2201'::text) AND (target_month_ = '201908'::bpchar))
  • Rows Removed by Filter: 110691
  • CStore File: /var/lib/pgsql/9.4/data/cstore_fdw/16385/56820
  • CStore File Size: 3383365
6. 1,184.639 1,213.035 ↓ 1,585.7 4,757 4,757

Materialize (cost=0.00..1,823.74 rows=3 width=260) (actual time=0.002..0.255 rows=4,757 loops=4,757)

7. 28.396 28.396 ↓ 1,585.7 4,757 1

Foreign Scan on sp_mi_abc_month smam2 (cost=0.00..1,823.72 rows=3 width=260) (actual time=11.243..28.396 rows=4,757 loops=1)

  • Filter: (((dealer_code_)::text = 'UA2201'::text) AND (target_month_ = '201908'::bpchar))
  • Rows Removed by Filter: 110691
  • CStore File: /var/lib/pgsql/9.4/data/cstore_fdw/16385/56820
  • CStore File Size: 3383365
8. 4,205.589 4,205.589 ↓ 155.0 155 1

Foreign Scan on sp_mi_abc_month smam1 (cost=0.00..2,227.34 rows=1 width=276) (actual time=4,200.960..4,205.589 rows=155 loops=1)

  • Filter: (((dealer_code_)::text = 'UA2201'::text) AND (target_month_ = '201908'::bpchar) AND (target_day_ = $0))
  • Rows Removed by Filter: 51168
  • CStore File: /var/lib/pgsql/9.4/data/cstore_fdw/16385/56820
  • CStore File Size: 3383365
Planning time : 2.680 ms