explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m2L0

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 21,274.149 ↑ 1.0 25 1

Limit (cost=4.70..1,545.30 rows=25 width=544) (actual time=11,300.082..21,274.149 rows=25 loops=1)

2. 0.160 21,274.130 ↑ 76.6 25 1

Nested Loop Left Join (cost=4.70..118,076.26 rows=1,916 width=544) (actual time=11,300.081..21,274.130 rows=25 loops=1)

3. 0.764 21,273.820 ↑ 76.6 25 1

Nested Loop Left Join (cost=4.59..117,729.16 rows=1,916 width=384) (actual time=11,300.035..21,273.820 rows=25 loops=1)

  • Join Filter: (t1._idrref = t8.fld15823rref)
  • Rows Removed by Join Filter: 5546
4. 0.936 20,725.356 ↑ 76.6 25 1

Nested Loop Left Join (cost=1.27..117,702.82 rows=1,916 width=352) (actual time=10,752.696..20,725.356 rows=25 loops=1)

  • Join Filter: (t1._idrref = t6.fld15892rref)
  • Rows Removed by Join Filter: 6555
5. 0.049 20,308.045 ↑ 76.6 25 1

Nested Loop Left Join (cost=1.00..117,676.51 rows=1,916 width=320) (actual time=10,336.691..20,308.045 rows=25 loops=1)

  • Join Filter: (t1._idrref = t5._fld15410rref)
  • Rows Removed by Join Filter: 25
6. 25.911 20,265.021 ↑ 76.6 25 1

Nested Loop (cost=0.28..116,357.89 rows=1,916 width=278) (actual time=10,293.716..20,265.021 rows=25 loops=1)

7. 20,181.475 20,181.475 ↑ 2.9 57,635 1

Index Scan using _reference129_5 on _reference129 t1 (cost=0.22..104,351.02 rows=164,421 width=278) (actual time=31.510..20,181.475 rows=57,635 loops=1)

  • Index Cond: (_fld767 = '334508'::numeric)
  • Filter: (_folder AND (NOT _fld2979) AND (_fld2997rref = ANY ('{"\\\\xae2229cc117b567d47d13de355a3f7e4","\\\\x9ebb1df93b741d6b437b1462bb571f86","\\\\xa8dfeeb4c78616c5487420b4a65eacc7","\\\\xbdaad93bd267293a4ddf429878c63ce8"}'::bytea[])))
  • Rows Removed by Filter: 57
8. 57.635 57.635 ↓ 0.0 0 57,635

Index Only Scan using tmpind_0 on tt422 t12 (cost=0.06..0.07 rows=1 width=17) (actual time=0.001..0.001 rows=0 loops=57,635)

  • Index Cond: (_reffieldrref = t1._parentidrref)
  • Heap Fetches: 25
9. 0.007 42.975 ↑ 1.0 1 25

Materialize (cost=0.72..1,295.62 rows=1 width=61) (actual time=1.719..1.719 rows=1 loops=25)

10. 0.006 42.968 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.72..1,295.62 rows=1 width=61) (actual time=42.967..42.968 rows=1 loops=1)

  • Join Filter: ((t5._fld15414_type = '\\x08'::bytea) AND (t5._fld15414_rtref = '\\x0000004d'::bytea))
11. 0.008 42.947 ↑ 1.0 1 1

Nested Loop (cost=0.55..1,295.41 rows=1 width=56) (actual time=42.946..42.947 rows=1 loops=1)

12. 0.009 24.394 ↑ 303.0 1 1

GroupAggregate (cost=0.28..293.70 rows=303 width=65) (actual time=24.394..24.394 rows=1 loops=1)

  • Group Key: t4._fld15410rref, t4._fld15409rref, t4._fld15411rref
13. 24.385 24.385 ↑ 151.5 2 1

Index Scan using _inforg15408_bydims on _inforg15408 t4 (cost=0.28..289.45 rows=303 width=65) (actual time=17.186..24.385 rows=2 loops=1)

  • Index Cond: ((_fld767 = '334508'::numeric) AND (_fld15409rref = '\\x5d9700505689f2c011e6b25462bdac26'::bytea) AND (_fld15411rref = '\\x00000000000000000000000000000000'::bytea) AND (_period <= '2019-05-15 00:00:00'::timestamp without time zone))
  • Filter: _fld15413
14. 18.545 18.545 ↑ 1.0 1 1

Index Scan using _inforg15408_bydims15419 on _inforg15408 t5 (cost=0.28..3.30 rows=1 width=102) (actual time=18.545..18.545 rows=1 loops=1)

  • Index Cond: ((_fld767 = '334508'::numeric) AND (_fld15411rref = t4._fld15411rref) AND (_period = (max(t4._period))) AND (_fld15409rref = t4._fld15409rref) AND (_fld15410rref = t4._fld15410rref))
15. 0.015 0.015 ↓ 0.0 0 1

Index Scan using _reference77hpk on _reference77 t11 (cost=0.17..0.19 rows=1 width=22) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((_fld767 = '334508'::numeric) AND (t5._fld15414_rrref = _idrref))
16. 0.600 416.375 ↓ 262.0 262 25

Materialize (cost=0.27..3.32 rows=1 width=49) (actual time=1.163..16.655 rows=262 loops=25)

17. 0.052 415.775 ↓ 273.0 273 1

Subquery Scan on t6 (cost=0.27..3.32 rows=1 width=49) (actual time=29.071..415.775 rows=273 loops=1)

18. 0.475 415.723 ↓ 273.0 273 1

GroupAggregate (cost=0.27..3.31 rows=1 width=49) (actual time=29.070..415.723 rows=273 loops=1)

  • Group Key: t7._fld15892rref
  • Filter: (sum(t7._fld15897) <> '0'::numeric)
19. 415.248 415.248 ↓ 291.0 291 1

Index Scan using _accumrg15899_bydims on _accumrgt15899 t7 (cost=0.27..3.29 rows=1 width=21) (actual time=23.325..415.248 rows=291 loops=1)

  • Index Cond: ((_fld767 = '334508'::numeric) AND (_period = '3999-11-01 00:00:00'::timestamp without time zone) AND (_fld15891rref = '\\x5d9700505689f2c011e6b254626db2b6'::bytea))
  • Filter: ((_fld15897 <> '0'::numeric) AND (_fld15897 <> '0'::numeric))
  • Rows Removed by Filter: 116
20. 0.467 547.700 ↓ 222.0 222 25

Materialize (cost=3.32..3.35 rows=1 width=49) (actual time=21.880..21.908 rows=222 loops=25)

21. 0.026 547.233 ↓ 231.0 231 1

Subquery Scan on t8 (cost=3.32..3.35 rows=1 width=49) (actual time=546.972..547.233 rows=231 loops=1)

22. 0.214 547.207 ↓ 231.0 231 1

GroupAggregate (cost=3.32..3.34 rows=1 width=49) (actual time=546.971..547.207 rows=231 loops=1)

  • Group Key: t9._fld15823rref
  • Filter: (sum(t9._fld15827) <> '0'::numeric)
23. 0.430 546.993 ↓ 245.0 245 1

Sort (cost=3.32..3.32 rows=1 width=21) (actual time=546.929..546.993 rows=245 loops=1)

  • Sort Key: t9._fld15823rref
  • Sort Method: quicksort Memory: 44kB
24. 546.563 546.563 ↓ 245.0 245 1

Index Scan using _accumrgt15850_1 on _accumrgt15850 t9 (cost=0.28..3.30 rows=1 width=21) (actual time=33.497..546.563 rows=245 loops=1)

  • Index Cond: ((_fld767 = '334508'::numeric) AND (_period = '3999-11-01 00:00:00'::timestamp without time zone) AND (_fld15820rref = '\\x5d9700505689f2c011e6b254626db2b6'::bytea) AND (_fld15821_type = '\\x08'::bytea) AND (_fld15821_rtref = '\\x000000db'::bytea))
  • Filter: ((_fld15826rref <> '\\x00000000000000000000000000000000'::bytea) AND (_fld15827 <> '0'::numeric) AND (_fld15827 <> '0'::numeric))
  • Rows Removed by Filter: 496
25. 0.150 0.150 ↓ 0.0 0 25

Index Scan using _reference35hpk on _reference35 t10 (cost=0.11..0.13 rows=1 width=18) (actual time=0.006..0.006 rows=0 loops=25)

  • Index Cond: ((_fld767 = '334508'::numeric) AND (t1._fld2957rref = _idrref))