explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vPV2

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.006 ↓ 0.0 0 1

Nested Loop (cost=1,000.00..1,101,421.59 rows=1 width=218) (actual time=0.006..0.006 rows=0 loops=1)

  • Join Filter: (((daily_revenue_summary.server)::text = (revenue_deductions.server)::text) AND (daily_revenue_summary.platform_id = revenue_deductions.platform_id) AND (daily_revenue_summary.brand_id = revenue_deductions.brand_id))
2. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on revenue_deductions (cost=0.00..10.53 rows=1 width=186) (actual time=0.005..0.005 rows=0 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)
3. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..1,099,937.29 rows=84,216 width=218) (never executed)

  • Workers Planned: 4
  • Workers Launched: 0
4. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on daily_revenue_summary (cost=0.00..1,090,515.69 rows=21,054 width=218) (never executed)

  • Filter: (date_trunc('month'::text, (revenue_date)::timestamp with time zone) = '2020-01-01 00:00:00+05:30'::timestamp with time zone)
Planning time : 0.556 ms
Execution time : 0.072 ms