explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6xWP

Settings
# exclusive inclusive rows x rows loops node
1. 321.307 43,690.995 ↓ 1,763.8 783,138 1

Gather (cost=1,000.00..1,585,390.75 rows=444 width=367) (actual time=2.299..43,690.995 rows=783,138 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
2. 43,369.688 43,369.688 ↓ 1,553.8 97,892 8 / 8

Parallel Seq Scan on invoice_summary (cost=0.00..1,584,346.35 rows=63 width=367) (actual time=0.476..43,369.688 rows=97,892 loops=8)

  • Filter: ((upper((product)::text) = 'SLOTS'::text) AND (date_trunc('MONTH'::text, (summary)::timestamp with time zone) = date_trunc('MONTH'::text, ('2020-02-01'::date)::timestamp with time zone)))
  • Rows Removed by Filter: 2,161,409
Planning time : 0.294 ms
Execution time : 43,760.430 ms