explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sjmq

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

Limit (cost=92.94..92.95 rows=1 width=605) (actual time=0.102..0.102 rows=0 loops=1)

2. 0.023 0.102 ↓ 0.0 0 1

Sort (cost=92.94..92.95 rows=1 width=605) (actual time=0.102..0.102 rows=0 loops=1)

  • Sort Key: t1._date_time, t1._idrref
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.079 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.11..92.93 rows=1 width=605) (actual time=0.079..0.079 rows=0 loops=1)

4. 0.000 0.079 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.69..84.49 rows=1 width=591) (actual time=0.079..0.079 rows=0 loops=1)

5. 0.001 0.079 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.40..76.19 rows=1 width=566) (actual time=0.079..0.079 rows=0 loops=1)

6. 0.000 0.078 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.97..67.74 rows=1 width=545) (actual time=0.078..0.078 rows=0 loops=1)

7. 0.000 0.078 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.56..59.31 rows=1 width=438) (actual time=0.078..0.078 rows=0 loops=1)

8. 0.000 0.078 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.28..50.96 rows=1 width=408) (actual time=0.078..0.078 rows=0 loops=1)

9. 0.000 0.078 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.00..42.65 rows=1 width=383) (actual time=0.078..0.078 rows=0 loops=1)

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

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

11. 0.000 0.078 ↓ 0.0 0 1

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

12. 0.000 0.078 ↓ 0.0 0 1

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

  • -> Index Scan using _reference28_pkey on _reference28 t3 (cost=0.43..8.45 rows=1 width=38) (never execu
13. 0.078 0.078 ↓ 0.0 0 1

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

  • -> 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
  • -> Index Scan using _reference52_pkey on _reference52 t2 (cost=0.29..8.31 rows=1 width=34) (never
  • Index Cond: (t1._fld2859rref = _idrref)
  • Index Cond: (t1._fld2862rref = _idrref)
14. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Seq Scan on _reference36 t6 (cost=0.00..2.36 rows=36 width=48) (never executed)

17. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (t1._fld2848rref = _idrref)
Planning time : 14.203 ms
Execution time : 0.401 ms