explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KA0R

Settings
# exclusive inclusive rows x rows loops node
1. 157.714 859,190.351 ↓ 98,962.5 1,088,587 1

Nested Loop (cost=0.56..2,891,667.99 rows=11 width=219) (actual time=1,683.235..859,190.351 rows=1,088,587 loops=1)

2. 5.587 5.587 ↓ 31.1 342 1

Seq Scan on revenue_deductions (cost=0.00..74.62 rows=11 width=21) (actual time=1.554..5.587 rows=342 loops=1)

  • Filter: (date_trunc('MONTH'::text, (date_month)::timestamp with time zone) = '2020-01-01 00:00:00+05:30'::timestamp with time zone)
  • Rows Removed by Filter: 1924
3. 859,027.050 859,027.050 ↓ 3,183.0 3,183 342

Index Scan using daily_revenue_summary_unq on daily_revenue_summary (cost=0.56..262,872.11 rows=1 width=219) (actual time=1,993.250..2,511.775 rows=3,183 loops=342)

  • Index Cond: (((server)::text = (revenue_deductions.server)::text) AND (platform_id = revenue_deductions.platform_id) AND (brand_id = revenue_deductions.brand_id))
  • Filter: (date_trunc('month'::text, (revenue_date)::timestamp with time zone) = '2020-01-01 00:00:00+05:30'::timestamp with time zone)
  • Rows Removed by Filter: 23903
Planning time : 2.076 ms
Execution time : 859,227.515 ms