explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ncX0

Settings
# exclusive inclusive rows x rows loops node
1. 1.198 128,204.844 ↓ 155.0 155 1

HashAggregate (cost=243,869,121.78..243,869,121.80 rows=1 width=276) (actual time=128,204.766..128,204.844 rows=155 loops=1)

  • Group Key: smam1.product_category_description_, smam1.abc_category_
2. 69.094 128,203.646 ↓ 155.0 155 1

Foreign Scan on sp_mi_abc_month smam1 (cost=0.00..243,869,121.76 rows=1 width=276) (actual time=124,044.895..128,203.646 rows=155 loops=1)

  • Filter: (((dealer_code_)::text = 'UA2201'::text) AND (target_month_ = '201908'::bpchar) AND (target_day_ = (SubPlan 1)))
  • Rows Removed by Filter: 51168
  • CStore File: /var/lib/pgsql/9.4/data/cstore_fdw/16385/56820
  • CStore File Size: 3383365
3.          

SubPlan (forForeign Scan)

4. 808.690 128,134.552 ↑ 1.0 1 4,757

Aggregate (cost=2,112.34..2,112.35 rows=1 width=36) (actual time=26.935..26.936 rows=1 loops=4,757)

5. 127,325.862 127,325.862 ↓ 164.0 164 4,757

Foreign Scan on sp_mi_abc_month smam2 (cost=0.00..2,112.34 rows=1 width=36) (actual time=10.884..26.766 rows=164 loops=4,757)

  • Filter: (((smam1.dealer_code_)::text = (dealer_code_)::text) AND (smam1.target_month_ = target_month_) AND ((smam1.product_category_)::text = (product_category_)::text))
  • Rows Removed by Filter: 115284
  • CStore File: /var/lib/pgsql/9.4/data/cstore_fdw/16385/56820
  • CStore File Size: 3383365
Planning time : 5.623 ms