explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fLed

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 4,621.751 ↓ 0.0 0 1

Finalize GroupAggregate (cost=1,604,377.76..1,604,458.80 rows=444 width=145) (actual time=4,621.751..4,621.751 rows=0 loops=1)

  • Group Key: (to_char((invoice_summary.summary)::timestamp with time zone, 'yyyy-mm'::text)), invoice_summary.server, invoice_summary.brand_id, invoice_summary.platform_id
2. 13.502 4,621.748 ↓ 0.0 0 1

Gather Merge (cost=1,604,377.76..1,604,434.46 rows=441 width=145) (actual time=4,621.748..4,621.748 rows=0 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
3. 0.006 4,608.246 ↓ 0.0 0 8 / 8

Partial GroupAggregate (cost=1,603,377.64..1,603,380.32 rows=63 width=145) (actual time=4,608.246..4,608.246 rows=0 loops=8)

  • Group Key: (to_char((invoice_summary.summary)::timestamp with time zone, 'yyyy-mm'::text)), invoice_summary.server, invoice_summary.brand_id, invoice_summary.platform_id
4. 0.380 4,608.240 ↓ 0.0 0 8 / 8

Sort (cost=1,603,377.64..1,603,377.80 rows=63 width=88) (actual time=4,608.240..4,608.240 rows=0 loops=8)

  • Sort Key: invoice_summary.server, invoice_summary.brand_id, invoice_summary.platform_id
  • Sort Method: quicksort Memory: 25kB
5. 4,607.860 4,607.860 ↓ 0.0 0 8 / 8

Parallel Seq Scan on invoice_summary (cost=0.00..1,603,375.75 rows=63 width=88) (actual time=4,607.860..4,607.860 rows=0 loops=8)

  • Filter: ((date_trunc('MONTH'::text, (summary)::timestamp with time zone) = '2020-02-01 00:00:00+05:30'::timestamp with time zone) AND (to_char((summary)::timestamp with time zone, 'yyyy-mm'::text) = '01/02/2020'::text) AND ((server)::text = ANY ('{DENMARK,DENMARK1,DENMARK2,TAIWAN,TAIWAN1,GIB,GIB1,BAHAMAS}'::text[])))
  • Rows Removed by Filter: 2209817
Planning time : 0.894 ms
Execution time : 4,634.666 ms