explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OxCS

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 232,939.978 ↓ 0.0 0 1

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

2. 0.005 232,939.974 ↓ 0.0 0 1

Nested Loop (cost=0.84..312,505.56 rows=6,663 width=30) (actual time=232,939.974..232,939.974 rows=0 loops=1)

3. 232,939.969 232,939.969 ↓ 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,413.18 rows=6,663 width=30) (actual time=232,939.969..232,939.969 rows=0 loops=1)

  • Index Cond: ((event = 'APPEL'::text) AND (compte_pda_id = '7679'::bigint))
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'::bigint)
  • Heap Fetches: 0