explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BcPL : Optimization for: Optimization for: Optimization for: Optimization for: plan #Obq7; plan #Ld2K; plan #APM7; plan #lnPl

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 843.470 1,601.023 ↑ 33.3 6 1

GroupAggregate (cost=259,114.56..259,197.04 rows=200 width=19) (actual time=779.387..1,601.023 rows=6 loops=1)

  • Group Key: events_2019_11_29.type
2. 549.861 757.553 ↓ 32.7 263,078 1

Sort (cost=259,114.56..259,134.68 rows=8,048 width=900) (actual time=642.812..757.553 rows=263,078 loops=1)

  • Sort Key: events_2019_11_29.type
  • Sort Method: external merge Disk: 269264kB
3. 0.000 207.692 ↓ 32.7 263,078 1

Gather (cost=1,000.00..258,592.47 rows=8,048 width=900) (actual time=0.477..207.692 rows=263,078 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
4. 4.068 229.588 ↓ 26.1 52,616 5

Parallel Append (cost=0.00..256,787.67 rows=2,013 width=900) (actual time=0.015..229.588 rows=52,616 loops=5)

  • Subplans Removed: 1
5. 225.520 225.520 ↓ 26.2 52,616 5

Parallel Seq Scan on events_2019_11_29 (cost=0.00..256,774.19 rows=2,012 width=900) (actual time=0.014..225.520 rows=52,616 loops=5)

  • Filter: (("timestamp" >= '2019-11-29 00:00:00+00'::timestamp with time zone) AND ("timestamp" <= '2019-11-29 23:59:59.999'::timestamp without time zone) AND ((value ->> 'baseAID'::text) = ANY ('{bandsintown}'::text[])) AND (type = ANY ('{PAGE_LOAD,PAGE_VIEW,TRUE_PAGE_VIEW,INT
  • Rows Removed by Filter: 345305
Planning time : 1.510 ms
Execution time : 1,631.729 ms