explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s9U7

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 3.474 ↑ 1.0 50 1

Limit (cost=1.27..417.80 rows=50 width=438) (actual time=0.158..3.474 rows=50 loops=1)

2. 0.142 3.466 ↑ 24,636.8 50 1

Nested Loop Left Join (cost=1.27..10,261,815.27 rows=1,231,839 width=438) (actual time=0.157..3.466 rows=50 loops=1)

3. 0.210 0.774 ↑ 24,636.8 50 1

Nested Loop (cost=0.85..980,174.00 rows=1,231,839 width=349) (actual time=0.063..0.774 rows=50 loops=1)

4. 0.114 0.114 ↑ 24,636.8 50 1

Index Scan Backward using _document369_bydocdate_trls on _document369 t1 (cost=0.43..375,007.26 rows=1,231,839 width=273) (actual time=0.032..0.114 rows=50 loops=1)

  • Index Cond: (_fld717 = '0'::numeric)
5. 0.450 0.450 ↑ 1.0 1 50

Index Scan using _inforg18872_bydims_r on _inforg18872 t2 (cost=0.43..0.48 rows=1 width=93) (actual time=0.009..0.009 rows=1 loops=50)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld18873rref = t1._idrref))
6. 0.300 0.300 ↓ 0.0 0 50

Index Scan using _inforg20333_bydims_r on _inforg20333 t3 (cost=0.42..0.44 rows=1 width=42) (actual time=0.006..0.006 rows=0 loops=50)

  • Index Cond: ((_fld717 = '0'::numeric) AND (t1._idrref = _fld20334rref))
7.          

SubPlan (for Nested Loop Left Join)

8. 0.050 0.600 ↓ 0.0 0 50

Limit (cost=0.55..2.99 rows=1 width=32) (actual time=0.012..0.012 rows=0 loops=50)

9. 0.550 0.550 ↓ 0.0 0 50

Index Scan using _inforg18529_bydims_rrss on _inforg18529 t4 (cost=0.55..2.99 rows=1 width=32) (actual time=0.011..0.011 rows=0 loops=50)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld18531_type = '\\010'::bytea) AND (_fld18531_rtref = '\\000\\000\\001q'::bytea) AND (_fld18531_rrref = t1._idrref) AND (_fld18532rref = '\\277\\252;\\356tw;,@\\0059!G\\257\\225{'::bytea))
  • Filter: ((_fld19313rref = '\\310\\2070Z:wN\\241\\021\\350e\\006\\034;\\347z'::bytea) AND (_fld18535rref = '\\207\\250\\034O8\\316\\032\\303J""q3\\311Bv:'::bytea))
10. 0.050 0.550 ↓ 0.0 0 50

Limit (cost=0.55..2.99 rows=1 width=32) (actual time=0.011..0.011 rows=0 loops=50)

11. 0.500 0.500 ↓ 0.0 0 50

Index Scan using _inforg18529_bydims_rrss on _inforg18529 t5 (cost=0.55..2.99 rows=1 width=32) (actual time=0.010..0.010 rows=0 loops=50)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld18531_type = '\\010'::bytea) AND (_fld18531_rtref = '\\000\\000\\001q'::bytea) AND (_fld18531_rrref = t1._idrref) AND (_fld18532rref = '\\277\\252;\\356tw;,@\\0059!G\\257\\225{'::bytea))
  • Filter: (_fld19313rref = '\\310\\2070Z:wN\\241\\021\\350e\\006\\034;\\347z'::bytea)
12. 0.000 0.550 ↓ 0.0 0 50

Limit (cost=0.55..2.99 rows=1 width=32) (actual time=0.011..0.011 rows=0 loops=50)

13. 0.550 0.550 ↓ 0.0 0 50

Index Scan using _inforg18529_bydims_rrss on _inforg18529 t6 (cost=0.55..2.99 rows=1 width=32) (actual time=0.011..0.011 rows=0 loops=50)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld18531_type = '\\010'::bytea) AND (_fld18531_rtref = '\\000\\000\\001q'::bytea) AND (_fld18531_rrref = t1._idrref) AND (_fld18532rref = '\\230\\320\\3608\\313\\264\\241\\330FP>]\\026\\343a (...)
  • Filter: (_fld18535rref = '\\276\\203\\321x\\271\\330H\\217I\\255\\035EX\\240T\\233'::bytea)
14. 0.050 0.550 ↓ 0.0 0 50

Limit (cost=0.55..2.98 rows=1 width=32) (actual time=0.011..0.011 rows=0 loops=50)

15. 0.500 0.500 ↓ 0.0 0 50

Index Only Scan using _inforg18529_bydims_rrss on _inforg18529 t7 (cost=0.55..2.98 rows=1 width=32) (actual time=0.010..0.010 rows=0 loops=50)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld18531_type = '\\010'::bytea) AND (_fld18531_rtref = '\\000\\000\\001q'::bytea) AND (_fld18531_rrref = t1._idrref) AND (_fld18532rref = '\\230\\320\\3608\\313\\264\\241\\330FP>]\\026\\343a (...)
  • Heap Fetches: 0
Planning time : 5.268 ms
Execution time : 3.906 ms