explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fV39

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 3,004.059 ↑ 1.0 1 1

Finalize Aggregate (cost=1,572,661.17..1,572,661.18 rows=1 width=8) (actual time=3,004.059..3,004.059 rows=1 loops=1)

2. 14.821 3,004.047 ↓ 1.1 8 1

Gather (cost=1,572,660.44..1,572,661.15 rows=7 width=8) (actual time=3,004.002..3,004.047 rows=8 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
3. 8.369 2,989.226 ↑ 1.0 1 8 / 8

Partial Aggregate (cost=1,571,660.44..1,571,660.45 rows=1 width=8) (actual time=2,989.226..2,989.226 rows=1 loops=8)

4. 2,980.857 2,980.857 ↓ 1,553.8 97,892 8 / 8

Parallel Seq Scan on invoice_summary (cost=0.00..1,571,660.28 rows=63 width=0) (actual time=540.787..2,980.857 rows=97,892 loops=8)

  • 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: 2161409
Planning time : 0.302 ms
Execution time : 3,021.533 ms