explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O5oXG

Settings
# exclusive inclusive rows x rows loops node
1. 342.578 2,570.008 ↓ 8.8 783,138 1

Gather (cost=1,000.00..1,575,412.49 rows=88,734 width=399) (actual time=1.328..2,570.008 rows=783,138 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
2. 2,227.430 2,227.430 ↓ 7.7 97,892 8 / 8

Parallel Seq Scan on invoice_summary (cost=0.00..1,565,348.94 rows=12,676 width=399) (actual time=0.136..2,227.430 rows=97,892 loops=8)

  • Filter: (((product)::text = 'SLOTS'::text) AND (date_trunc('MONTH'::text, (summary)::timestamp with time zone) = '2020-02-01 00:00:00+05:30'::timestamp with time zone))
  • Rows Removed by Filter: 2,161,409
Planning time : 0.361 ms
Execution time : 2,612.786 ms