explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mIkn

Settings
# exclusive inclusive rows x rows loops node
1. 6,718.717 25,448.150 ↓ 0.0 0 1

Insert on invoice_summary_temp (cost=0.00..1,914,185.09 rows=444 width=399) (actual time=25,448.150..25,448.150 rows=0 loops=1)

2. 18,729.433 18,729.433 ↓ 1,465.3 650,608 1

Seq Scan on invoice_summary (cost=0.00..1,914,185.09 rows=444 width=399) (actual time=0.047..18,729.433 rows=650,608 loops=1)

  • Filter: ((upper((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: 17,291,250
Planning time : 0.476 ms
Execution time : 25,448.404 ms