explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q16m

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.097 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.90..40.67 rows=1 width=323) (actual time=0.096..0.097 rows=1 loops=1)

2. 0.071 0.071 ↑ 1.0 1 1

Index Scan using _reference186hpk on _reference186 t1 (cost=0.29..4.31 rows=1 width=34) (actual time=0.071..0.071 rows=1 loops=1)

  • Index Cond: ((_fld1290 = '480'::numeric) AND (_idrref = '\\200\\324\\000PV\\201!\\254\\021\\350\\371S\\303\\325\\333\\372'::bytea))
3. 0.003 0.020 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.61..36.35 rows=1 width=289) (actual time=0.020..0.020 rows=0 loops=1)

4. 0.017 0.017 ↓ 0.0 0 1

Index Scan using _reference186hpk on _reference186 t2 (cost=0.29..4.31 rows=1 width=34) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((_fld1290 = '480'::numeric) AND (t1._parentidrref = _idrref))
5. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=2.32..32.03 rows=1 width=255) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Index Scan using _reference186hpk on _reference186 t3 (cost=0.29..3.98 rows=1 width=34) (never executed)

  • Index Cond: ((_fld1290 = '480'::numeric) AND (t2._parentidrref = _idrref))
7. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=2.03..28.04 rows=1 width=221) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Index Scan using _reference186hpk on _reference186 t4 (cost=0.29..3.98 rows=1 width=34) (never executed)

  • Index Cond: ((_fld1290 = '480'::numeric) AND (t3._parentidrref = _idrref))
9. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.74..24.04 rows=1 width=187) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Index Scan using _reference186hpk on _reference186 t5 (cost=0.29..3.98 rows=1 width=34) (never executed)

  • Index Cond: ((_fld1290 = '480'::numeric) AND (t4._parentidrref = _idrref))
11. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.45..20.05 rows=1 width=153) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Index Scan using _reference186hpk on _reference186 t6 (cost=0.29..3.98 rows=1 width=34) (never executed)

  • Index Cond: ((_fld1290 = '480'::numeric) AND (t5._parentidrref = _idrref))
13. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.16..16.05 rows=1 width=119) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Index Scan using _reference186hpk on _reference186 t7 (cost=0.29..3.98 rows=1 width=34) (never executed)

  • Index Cond: ((_fld1290 = '480'::numeric) AND (t6._parentidrref = _idrref))
15. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.87..12.06 rows=1 width=85) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Index Scan using _reference186hpk on _reference186 t8 (cost=0.29..3.98 rows=1 width=34) (never executed)

  • Index Cond: ((_fld1290 = '480'::numeric) AND (t7._parentidrref = _idrref))
17. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.58..8.06 rows=1 width=51) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Index Scan using _reference186hpk on _reference186 t9 (cost=0.29..3.98 rows=1 width=34) (never executed)

  • Index Cond: ((_fld1290 = '480'::numeric) AND (t8._parentidrref = _idrref))
19. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference186hpk on _reference186 t10 (cost=0.29..3.98 rows=1 width=17) (never executed)

  • Index Cond: ((_fld1290 = '480'::numeric) AND (_idrref = t9._parentidrref))
  • Heap Fetches: 0