explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XXEX

Settings
# exclusive inclusive rows x rows loops node
1. 16.828 13,093.933 ↑ 1.0 1 1

Aggregate (cost=10,069.81..10,069.82 rows=1 width=8) (actual time=13,093.933..13,093.933 rows=1 loops=1)

2. 13,077.105 13,077.105 ↓ 1.3 53,873 1

Index Only Scan using attivita_fatte_id_persona_id_azienda_id_applicazione_id_idx on attivita_fatte (cost=0.56..9,968.83 rows=40,392 width=4) (actual time=11.615..13,077.105 rows=53,873 loops=1)

  • Index Cond: (id_persona = 231157)
  • Heap Fetches: 4928
Planning time : 88.995 ms
Execution time : 13,094.060 ms