explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nEDg

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.438 ↑ 1.0 6 1

Limit (cost=1.15..9,873.46 rows=6 width=20) (actual time=0.163..0.438 rows=6 loops=1)

  • Output: p.id, p.date_heure, o.name
2. 0.003 0.436 ↑ 443.7 6 1

Nested Loop (cost=1.15..4,380,016.97 rows=2,662 width=20) (actual time=0.162..0.436 rows=6 loops=1)

  • Output: p.id, p.date_heure, o.name
3. 0.027 0.385 ↑ 443.7 6 1

Nested Loop (cost=0.87..4,379,975.39 rows=2,662 width=16) (actual time=0.116..0.385 rows=6 loops=1)

  • Output: p.id, p.date_heure, rel.is_presse_cycle_id
4. 0.078 0.078 ↑ 57,849.3 140 1

Index Scan Backward using is_presse_cycle_date_heure_index on public.is_presse_cycle p (cost=0.43..286,013.96 rows=8,098,902 width=12) (actual time=0.020..0.078 rows=140 loops=1)

  • Output: p.id, p.create_uid, p.create_date, p.write_uid, p.date_heure, p.write_date, p.presse_id
5. 0.280 0.280 ↓ 0.0 0 140

Index Only Scan using is_presse_cycle_of_rel_is_of_id_is_presse_cycle_id_key on public.is_presse_cycle_of_rel rel (cost=0.43..0.50 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=140)

  • Output: rel.is_of_id, rel.is_presse_cycle_id
  • Index Cond: ((rel.is_of_id = p.id) AND (rel.is_presse_cycle_id = 8774))
  • Heap Fetches: 6
6. 0.013 0.048 ↑ 1.0 1 6

Materialize (cost=0.28..8.31 rows=1 width=12) (actual time=0.008..0.008 rows=1 loops=6)

  • Output: o.name, o.id
7. 0.035 0.035 ↑ 1.0 1 1

Index Scan using is_of_pkey on public.is_of o (cost=0.28..8.30 rows=1 width=12) (actual time=0.035..0.035 rows=1 loops=1)

  • Output: o.name, o.id
  • Index Cond: (o.id = 8774)