explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LMGH

Settings
# exclusive inclusive rows x rows loops node
1. 692.713 2,443.832 ↓ 20.9 1,765,286 1

Gather (cost=1,000.00..884,709.01 rows=84,648 width=270) (actual time=1,042.533..2,443.832 rows=1,765,286 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
2. 1,751.119 1,751.119 ↓ 18.2 220,661 8 / 8

Parallel Seq Scan on invoice_summary ccgs (cost=0.00..875,244.20 rows=12,093 width=270) (actual time=1,023.380..1,751.119 rows=220,661 loops=8)

  • Filter: (date_trunc('MONTH'::text, (summary)::timestamp with time zone) = '2019-12-01 00:00:00+05:30'::timestamp with time zone)
  • Rows Removed by Filter: 2096668
Planning time : 0.356 ms
Execution time : 2,548.170 ms