explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8Ot4

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

XN HashAggregate (cost=178.31..191.61 rows=380 width=64) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

XN Seq Scan on fct_merchant_brand_performance_daily_20190308 (cost=0.00..92.97 rows=3,793 width=64) (actual rows= loops=)

  • Filter: ((merchant_customer_id = 142499351) AND (marketplace_id = 1) AND (dataset_date <= '2019-04-15'::date) AND (dataset_date > '2018-06-14'::date))