explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W1oC

Settings
# exclusive inclusive rows x rows loops node
1. 1.485 23,544.121 ↓ 9.2 9,205 1

Result (cost=62,634.10..62,899.37 rows=1,000 width=32) (actual time=23,445.338..23,544.121 rows=9,205 loops=1)

2. 100.416 23,542.636 ↓ 9.2 9,205 1

ProjectSet (cost=62,634.10..62,639.37 rows=1,000 width=32) (actual time=23,445.333..23,542.636 rows=9,205 loops=1)

3. 23,263.915 23,442.220 ↑ 1.0 1 1

Aggregate (cost=62,634.10..62,634.11 rows=1 width=32) (actual time=23,442.220..23,442.220 rows=1 loops=1)

4. 178.305 178.305 ↓ 1.0 9,999 1

Seq Scan on markslag_myrikilden_temp (cost=0.00..62,609.51 rows=9,835 width=1,600) (actual time=0.015..178.305 rows=9,999 loops=1)

  • Filter: (gid < 10000)
  • Rows Removed by Filter: 557242