explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9frz

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=0.84..47.74 rows=1 width=30) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..311,606.00 rows=6,643 width=30) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan Backward using log_pda_date_event_event_compte_pda_id_idx on log_pda logpda0_ (cost=0.56..311,513.87 rows=6,643 width=30) (actual rows= loops=)

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

Materialize (cost=0.28..9.10 rows=1 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = '7679'::bigint)