explain.depesz.com

PostgreSQL's explain analyze made readable

Result: auc1

Settings
# exclusive inclusive rows x rows loops node
1. 6.703 6.915 ↓ 0.0 0 1

Gather (cost=1,010.90..1,113,001.69 rows=1 width=218) (actual time=6.623..6.915 rows=0 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 0.195 0.212 ↓ 0.0 0 5 / 5

Hash Join (cost=10.90..1,112,001.59 rows=1 width=218) (actual time=0.212..0.212 rows=0 loops=5)

  • Hash Cond: ((date_trunc('MONTH'::text, (drs.revenue_date)::timestamp with time zone) = date_trunc('MONTH'::text, (rd.date_month)::timestamp with time zone)) AND ((drs.server)::text = (rd.server)::text) AND (drs.platform_id = rd.platform_id) AND (drs.brand_id = rd.brand_id))
3. 0.008 0.008 ↑ 21,054.0 1 5 / 5

Parallel Seq Scan on daily_revenue_summary drs (cost=0.00..1,111,569.60 rows=21,054 width=218) (actual time=0.008..0.008 rows=1 loops=5)

  • Filter: (date_trunc('month'::text, (revenue_date)::timestamp with time zone) = date_trunc('month'::text, ('2020-01-01'::date)::timestamp with time zone))
4. 0.000 0.009 ↓ 0.0 0 5 / 5

Hash (cost=10.30..10.30 rows=30 width=186) (actual time=0.009..0.009 rows=0 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
5. 0.009 0.009 ↓ 0.0 0 5 / 5

Seq Scan on revenue_deductions rd (cost=0.00..10.30 rows=30 width=186) (actual time=0.009..0.009 rows=0 loops=5)

Planning time : 0.392 ms
Execution time : 6.984 ms