explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IfrH

Settings
# exclusive inclusive rows x rows loops node
1. 7,427.170 32,590.891 ↓ 0.0 0 1

Insert on invoice_summary_temp (cost=0.00..2,002,986.42 rows=444 width=367) (actual time=32,590.891..32,590.891 rows=0 loops=1)

2. 25,163.721 25,163.721 ↓ 1,465.3 650,608 1

Seq Scan on invoice_summary (cost=0.00..2,002,986.42 rows=444 width=367) (actual time=0.037..25,163.721 rows=650,608 loops=1)

  • 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: 17291250
Planning time : 0.366 ms
Execution time : 32,591.133 ms