explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m3ZR

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1,055.493 ↓ 0.0 0 1

Limit (cost=0.84..47.74 rows=1 width=30) (actual time=1,055.493..1,055.493 rows=0 loops=1)

2. 0.002 1,055.491 ↓ 0.0 0 1

Nested Loop (cost=0.84..312,583.97 rows=6,665 width=30) (actual time=1,055.491..1,055.491 rows=0 loops=1)

3. 1,055.489 1,055.489 ↓ 0.0 0 1

Index Scan Backward using log_pda_date_event_event_compte_pda_id_idx on log_pda logpda0_ (cost=0.56..312,491.56 rows=6,665 width=30) (actual time=1,055.489..1,055.489 rows=0 loops=1)

  • Index Cond: ((event = 'APPEL'::text) AND (compte_pda_id = 7679))
4. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.28..9.10 rows=1 width=8) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Index Only Scan using compte_pda_id_idx on compte_pda comptepda1_ (cost=0.28..9.10 rows=1 width=8) (never executed)

  • Index Cond: (id = 7679)
  • Heap Fetches: 0