explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2TrX

Settings
# exclusive inclusive rows x rows loops node
1. 2.129 40.157 ↑ 1.0 1 1

Aggregate (cost=42,496.69..42,496.70 rows=1 width=8) (actual time=40.157..40.157 rows=1 loops=1)

2. 33.555 38.028 ↓ 1.1 12,348 1

Bitmap Heap Scan on attivita (cost=949.61..42,467.92 rows=11,508 width=4) (actual time=7.504..38.028 rows=12,348 loops=1)

  • Recheck Cond: (id_persona = 231157)
  • Heap Blocks: exact=10579
3. 4.473 4.473 ↓ 1.1 12,652 1

Bitmap Index Scan on attivita_id_persona_id_azienda_id_applicazione_idx (cost=0.00..946.74 rows=11,508 width=0) (actual time=4.473..4.473 rows=12,652 loops=1)

  • Index Cond: (id_persona = 231157)
Planning time : 0.212 ms
Execution time : 40.320 ms