explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rp8v : PG10-CountWithFilter-Parallel

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 192.856 ↑ 1.0 1 1

Finalize Aggregate (cost=47,816.41..47,816.42 rows=1 width=8) (actual time=192.855..192.856 rows=1 loops=1)

2. 5.833 192.848 ↓ 1.5 3 1

Gather (cost=47,816.20..47,816.41 rows=2 width=8) (actual time=190.543..192.848 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 13.822 187.015 ↑ 1.0 1 3

Partial Aggregate (cost=46,816.20..46,816.21 rows=1 width=8) (actual time=187.014..187.015 rows=1 loops=3)

4. 173.193 173.193 ↑ 1.4 20,097 3

Parallel Seq Scan on daily (cost=0.00..46,747.08 rows=27,648 width=0) (actual time=0.236..173.193 rows=20,097 loops=3)

  • Filter: (t_min < 0)
  • Rows Removed by Filter: 1281540
Planning time : 0.075 ms
Execution time : 193.038 ms