explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8ZQ3

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

XN Merge (cost=1,000,000,404,065.16..1,000,000,404,065.17 rows=2 width=136) (actual rows= loops=)

  • Merge Key: ((date(dataset_date) - '1970-01-01'::date) * 86400)
2. 0.000 0.000 ↓ 0.0

XN Network (cost=1,000,000,404,065.16..1,000,000,404,065.17 rows=2 width=136) (actual rows= loops=)

  • Send to leader
3. 0.000 0.000 ↓ 0.0

XN Sort (cost=1,000,000,404,065.16..1,000,000,404,065.17 rows=2 width=136) (actual rows= loops=)

  • Sort Key: ((date(dataset_date) - '1970-01-01'::date) * 86400)
4. 0.000 0.000 ↓ 0.0

XN HashAggregate (cost=404,064.94..404,065.15 rows=2 width=136) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

XN Subquery Scan foo (cost=21,430.24..404,064.84 rows=2 width=136) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

XN Append (cost=21,430.24..404,064.82 rows=2 width=96) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

XN Subquery Scan "*SELECT* 1" (cost=21,430.24..21,430.36 rows=1 width=96) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

XN HashAggregate (cost=21,430.24..21,430.35 rows=1 width=96) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

XN Seq Scan on fct_merchant_activity_daily_20190308 (cost=0.00..21,430.15 rows=2 width=96) (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))
10. 0.000 0.000 ↓ 0.0

XN Subquery Scan "*SELECT* 2" (cost=382,634.41..382,634.46 rows=1 width=16) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

XN HashAggregate (cost=382,634.41..382,634.45 rows=1 width=16) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

XN Seq Scan on fct_merchant_feedback_ratings_daily_20190308 (cost=0.00..382,632.35 rows=118 width=16) (actual rows= loops=)

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