explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mkTp

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.486 ↑ 1.0 8 1

Limit (cost=1.15..13,164.40 rows=8 width=20) (actual time=0.138..0.486 rows=8 loops=1)

  • Output: p.id, p.date_heure, o.name
2. 0.009 0.484 ↑ 332.8 8 1

Nested Loop (cost=1.15..4,380,073.33 rows=2,662 width=20) (actual time=0.138..0.484 rows=8 loops=1)

  • Output: p.id, p.date_heure, o.name
3. 0.020 0.435 ↑ 332.8 8 1

Nested Loop (cost=0.87..4,380,031.75 rows=2,662 width=16) (actual time=0.093..0.435 rows=8 loops=1)

  • Output: p.id, p.date_heure, rel.is_presse_cycle_id
4. 0.097 0.097 ↑ 50,937.2 159 1

Index Scan Backward using is_presse_cycle_date_heure_index on public.is_presse_cycle p (cost=0.43..286,016.57 rows=8,099,009 width=12) (actual time=0.021..0.097 rows=159 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.318 0.318 ↓ 0.0 0 159

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=159)

  • 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: 8
6. 0.003 0.040 ↑ 1.0 1 8

Materialize (cost=0.28..8.31 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=8)

  • Output: o.name, o.id
7. 0.037 0.037 ↑ 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.036..0.037 rows=1 loops=1)

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