explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YJxg

Settings
# exclusive inclusive rows x rows loops node
1. 520.749 1,410.593 ↑ 1.0 2 1

Gather (cost=459,161.31..464,846.31 rows=2 width=8) (actual time=1,268.983..1,410.593 rows=2 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.002 889.844 ↑ 1.0 1 3 / 3

Parallel Append (cost=459,160.31..464,845.11 rows=1 width=8) (actual time=889.843..889.844 rows=1 loops=3)

3. 37.057 467.010 ↑ 1.0 1 1 / 3

Aggregate (cost=464,845.09..464,845.10 rows=1 width=8) (actual time=1,401.030..1,401.030 rows=1 loops=1)

4. 429.953 429.953 ↓ 1.0 3,422,130 1 / 3

Seq Scan on rtpezocoav (cost=0.00..456,462.35 rows=3,353,094 width=0) (actual time=0.484..1,289.858 rows=3,422,130 loops=1)

  • Filter: (value_num < '10'::double precision)
  • Rows Removed by Filter: 17897762
5. 10.560 422.832 ↑ 1.0 1 1 / 3

Aggregate (cost=459,160.31..459,160.32 rows=1 width=8) (actual time=1,268.495..1,268.495 rows=1 loops=1)

6. 412.272 412.272 ↑ 1.0 1,032,420 1 / 3

Seq Scan on rtpezocoav rtpezocoav_1 (cost=0.00..456,462.35 rows=1,079,185 width=0) (actual time=0.621..1,236.816 rows=1,032,420 loops=1)

  • Filter: (value_num > '100'::double precision)
  • Rows Removed by Filter: 20287472
Planning time : 0.267 ms
Execution time : 1,410.656 ms