explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H5OG

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 97,887.718 ↑ 22.0 5 1

Finalize GroupAggregate (cost=1,000.62..415,786.63 rows=110 width=23) (actual time=49,944.747..97,887.718 rows=5 loops=1)

  • Group Key: type, status
2. 10,042.067 98,005.873 ↑ 21.0 21 1

Gather Merge (cost=1,000.62..415,782.23 rows=440 width=23) (actual time=8,643.392..98,005.873 rows=21 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 49.298 87,963.806 ↑ 27.5 4 5 / 5

Partial GroupAggregate (cost=0.56..414,729.76 rows=110 width=23) (actual time=6,821.175..87,963.806 rows=4 loops=5)

  • Group Key: type, status
4. 87,914.508 87,914.508 ↑ 1.2 87,019 5 / 5

Parallel Index Scan using monitoring_client_transaction_type_idx on monitoring_client_transaction tr (cost=0.56..413,919.89 rows=107,836 width=15) (actual time=145.108..87,914.508 rows=87,019 loops=5)

  • Index Cond: ((type)::text = 'DEPOSIT'::text)
  • Filter: ("timestamp" <= '2020-08-11 21:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 11,106
Planning time : 0.195 ms
Execution time : 98,005.971 ms