explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pcvp

Settings
# exclusive inclusive rows x rows loops node
1. 31.242 13,124.308 ↑ 1.0 1 1

Aggregate (cost=15,614.83..15,614.84 rows=1 width=8) (actual time=13,124.308..13,124.308 rows=1 loops=1)

2. 13,072.317 13,093.066 ↓ 4.1 16,440 1

Bitmap Heap Scan on attivita_fatte (cost=111.27..15,604.92 rows=3,962 width=4) (actual time=41.152..13,093.066 rows=16,440 loops=1)

  • Recheck Cond: (id_persona = 258171)
  • Heap Blocks: exact=15530
3. 20.749 20.749 ↓ 4.1 16,440 1

Bitmap Index Scan on attivita_fatte_id_persona_data_id_idx (cost=0.00..110.28 rows=3,962 width=0) (actual time=20.749..20.749 rows=16,440 loops=1)

  • Index Cond: (id_persona = 258171)
Planning time : 0.681 ms
Execution time : 13,124.631 ms