explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jt5s

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.276 ↑ 1.0 1 1

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

2. 0.004 0.275 ↑ 6,664.0 1 1

Nested Loop (cost=0.84..312,565.46 rows=6,664 width=30) (actual time=0.275..0.275 rows=1 loops=1)

3. 0.136 0.136 ↑ 6,664.0 1 1

Index Scan Backward using log_pda_date_event_event_compte_pda_id_idx on log_pda logpda0_ (cost=0.56..312,473.07 rows=6,664 width=30) (actual time=0.136..0.136 rows=1 loops=1)

  • Index Cond: ((event = 'APPEL'::text) AND (compte_pda_id = 6982))
4. 0.005 0.135 ↑ 1.0 1 1

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

5. 0.130 0.130 ↑ 1.0 1 1

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

  • Index Cond: (id = 6982)
  • Heap Fetches: 1