explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IuIQz

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=92.94..92.95 rows=1 width=606) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=92.94..92.95 rows=1 width=606) (actual rows= loops=)

  • Sort Key: t1._date_time, t1._idrref
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4.11..92.93 rows=1 width=606) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=3.69..84.49 rows=1 width=592) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=3.40..76.19 rows=1 width=567) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.97..67.74 rows=1 width=546) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.56..59.31 rows=1 width=439) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.28..50.96 rows=1 width=409) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.00..42.65 rows=1 width=384) (actual rows= loops=)

  • Join Filter: (t1._fld2853rref = t6._idrref)
10. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.00..39.84 rows=1 width=352) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.71..31.53 rows=1 width=335) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.29..23.10 rows=1 width=314) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.86..14.65 rows=1 width=293) (actual rows= loops=)

  • -> Index Scan using _document2794_idx_custom_4 on _document2794 t1 (cost=0.57..6.34 rows=1 width=
  • Index Cond: ((_fld2838_type = '\x5c303130'::bytea) AND (_fld2838_rtref = '\x5c3030305c3030305
14. 0.000 0.000 ↓ 0.0

Index Scan using _reference52_pkey on _reference52 t2 (cost=0.29..8.31 rows=1 width=34) (actual rows= loops=)

  • Index Cond: (t1._fld2859rref = _idrref)
15. 0.000 0.000 ↓ 0.0

Index Scan using _reference28_pkey on _reference28 t3 (cost=0.43..8.45 rows=1 width=38) (actual rows= loops=)

  • Index Cond: (t1._fld2862rref = _idrref)
16. 0.000 0.000 ↓ 0.0

Index Scan using _reference53_pkey on _reference53 t4 (cost=0.42..8.44 rows=1 width=38) (actual rows= loops=)

  • Index Cond: (t1._fld2852rref = _idrref)
17. 0.000 0.000 ↓ 0.0

Index Scan using _reference52_pkey on _reference52 t5 (cost=0.29..8.31 rows=1 width=34) (actual rows= loops=)

  • Index Cond: (t1._fld2860rref = _idrref)
18. 0.000 0.000 ↓ 0.0

Seq Scan on _reference36 t6 (cost=0.00..2.36 rows=36 width=64) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Index Scan using _reference85_pkey on _reference85 t7 (cost=0.29..8.30 rows=1 width=42) (actual rows= loops=)

  • Index Cond: (t1._fld2858rref = _idrref)
20. 0.000 0.000 ↓ 0.0

Index Scan using _reference70_pkey on _reference70 t8 (cost=0.27..8.29 rows=1 width=47) (actual rows= loops=)

  • Index Cond: (t1._fld2870rref = _idrref)
21. 0.000 0.000 ↓ 0.0

Index Scan using _reference47ng_pkey1 on _reference47 t9 (cost=0.42..8.44 rows=1 width=124) (actual rows= loops=)

  • Index Cond: (t1._fld2845rref = _idrref)
22. 0.000 0.000 ↓ 0.0

Index Scan using _reference28_pkey on _reference28 t10 (cost=0.43..8.45 rows=1 width=38) (actual rows= loops=)

  • Index Cond: (t1._fld2861rref = _idrref)
23. 0.000 0.000 ↓ 0.0

Index Scan using _reference85_pkey on _reference85 t11 (cost=0.29..8.30 rows=1 width=42) (actual rows= loops=)

  • Index Cond: (t1._fld2857rref = _idrref)
24. 0.000 0.000 ↓ 0.0

Index Scan using _reference31_pkey on _reference31 t12 (cost=0.42..8.44 rows=1 width=31) (actual rows= loops=)

  • Index Cond: (t1._fld2848rref = _idrref)