explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lnfb : новый индекс

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 13,720.140 ↑ 5.0 1 1

Nested Loop (cost=0.03..5,327.56 rows=5 width=128) (actual time=13,720.136..13,720.14 rows=1 loops=1)

  • Buffers: shared hit=1769636 read=12836
2. 0.070 0.070 ↑ 1.0 1 1

Index Scan using _reference22_pkey on _reference22 t13 (cost=0.03..3.04 rows=1 width=40) (actual time=0.067..0.07 rows=1 loops=1)

  • Index Cond: (t13._idrref = '\\332\\222\\000\\014)&\\343I\\021\\345 \\220l\\267\\032H'::bytea)
  • Buffers: shared read=3
3. 7.065 13,720.058 ↑ 5.0 1 1

Aggregate (cost=0..5,324.41 rows=5 width=286) (actual time=13,720.058..13,720.058 rows=1 loops=1)

  • Filter: ((CASE WHEN (sum((0.00::numeric(15,2))) IS NULL) THEN '0'::numeric ELSE sum((0.00::numeric(15,2))) END <> '0'::numeric) OR (CASE WHEN (sum((0.00::numeric(15,2))) IS NULL) THEN '0'::numeric ELSE sum((0.00::numeric(15,2))) END <> '0'::numeric) OR (CASE WHEN (sum(((t3._fld606 + t3._turnover620))) IS NULL) THEN '0'::numeric ELSE sum(((t3._fld606 + t3._turnover620))) END <> '0'::numeric) OR (CASE WHEN (sum((((t3._fld606 + t3._turnover620)) + (0.00::numeric(15,2)))) IS NULL) THEN '0'::numeric ELSE sum((((t3._fld606 + t3._turnover620)) + (0.00::numeric(15,2)))) END <> '0'::numeric) OR (CASE WHEN (sum((0.00::numeric(15,2))) IS NULL) THEN '0'::numeric ELSE sum((0.00::numeric(15,2))) END <> '0'::numeric) OR (CASE WHEN (sum((0.00::numeric(15,2))) IS NULL) THEN '0'::numeric ELSE sum((0.00::numeric(15,2))) END <> '0'::numeric) OR (CASE WHEN (sum(((t3._fld605 + t3._turnover617))) IS NULL) THEN '0'::numeric ELSE sum(((t3._fld605 + t3._turnover617))) END <> '0'::numeric) OR (CASE WHEN (sum((((t3._fld605 + t3._turnover617)) + (0.00::numeric(15,2)))) IS NULL) THEN '0'::numeric ELSE sum((((t3._fld605 + t3._turnover617)) + (0.00::numeric(15,2)))) END <> '0'::numeric))
  • Buffers: shared hit=1769636 read=12833
4. 1.066 13,712.993 ↓ 553.8 2,769 1

Append (cost=0..5,324.27 rows=5 width=212) (actual time=0.466..13,712.993 rows=2,769 loops=1)

  • Buffers: shared hit=1769636 read=12833
5. 178.354 178.354 ↓ 239.0 239 1

Seq Scan on _accrgat2634 t3 (cost=0..5,299.66 rows=1 width=202) (actual time=0.465..178.354 rows=239 loops=1)

  • Filter: ((t3._value1_type = '\\010'::bytea) AND (t3._value1_rtref = '\\000\\000\\000\\026'::bytea) AND (t3._value1_rrref = '\\332\\222\\000\\014)&\\343I\\021\\345 \\220l\\267\\032H'::bytea))
  • Buffers: shared read=12055
6. 0.047 40.684 ↓ 152.0 152 1

Subquery Scan on *SELECT* 2 (cost=0.1..6.15 rows=1 width=178) (actual time=0.247..40.684 rows=152 loops=1)

  • Buffers: shared hit=8542 read=70
7. 3.899 40.637 ↓ 152.0 152 1

Nested Loop (cost=0.1..6.14 rows=1 width=158) (actual time=0.245..40.637 rows=152 loops=1)

  • Buffers: shared hit=8542 read=70
8. 1.017 1.017 ↓ 243.0 243 1

Index Scan using _accrg601_byperiod_trn on _accrg601 t5 (cost=0.04..3.06 rows=1 width=63) (actual time=0.105..1.017 rows=243 loops=1)

  • Index Cond: ((t5._period >= '2019-04-12 00:00:00'::timestamp without time zone) AND (t5._period <= '2019-04-12 23:59:59'::timestamp without time zone))
  • Filter: (t5._active AND (t5._accountdtrref <> '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) AND (t5._fld602rref = '\\226\\331\\000\\014nF\\374\\255\\021\\335<H\\371f\\000\\014'::bytea))
  • Buffers: shared hit=18 read=42
9. 35.721 35.721 ↓ 105.0 105 243

Index Scan using _accrged637_byperiod_trnrn on _accrged637 t6 (cost=0.06..3.07 rows=1 width=69) (actual time=0.006..0.147 rows=105 loops=243)

  • Index Cond: ((t6._period >= '2019-04-12 00:00:00'::timestamp without time zone) AND (t6._period <= '2019-04-12 23:59:59'::timestamp without time zone) AND (t6._kindrref = '\\200\\226\\310\\357\\267\\312\\036YB|\\210\\271\\363\\336O\\024'::bytea) AND (t6._correspond = '0'::numeric))
  • Filter: ((t6._value_type = '\\010'::bytea) AND (t6._value_rtref = '\\000\\000\\000\\026'::bytea) AND (t6._value_rrref = '\\332\\222\\000\\014)&\\343I\\021\\345 \\220l\\267\\032H'::bytea))
  • Buffers: shared hit=8524 read=28
10. 0.007 36.260 ↓ 21.0 21 1

Subquery Scan on *SELECT* 3 (cost=0.1..6.15 rows=1 width=218) (actual time=0.322..36.26 rows=21 loops=1)

  • Buffers: shared hit=5555 read=7
11. 0.825 36.253 ↓ 21.0 21 1

Nested Loop (cost=0.1..6.14 rows=1 width=198) (actual time=0.321..36.253 rows=21 loops=1)

  • Buffers: shared hit=5555 read=7
12. 0.193 0.193 ↓ 243.0 243 1

Index Scan using _accrg601_byperiod_trn on _accrg601 t7 (cost=0.04..3.06 rows=1 width=63) (actual time=0.022..0.193 rows=243 loops=1)

  • Index Cond: ((t7._period >= '2019-04-12 00:00:00'::timestamp without time zone) AND (t7._period <= '2019-04-12 23:59:59'::timestamp without time zone))
  • Filter: (t7._active AND (t7._accountctrref <> '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) AND (t7._fld602rref = '\\226\\331\\000\\014nF\\374\\255\\021\\335<H\\371f\\000\\014'::bytea))
  • Buffers: shared hit=60
13. 35.235 35.235 ↓ 20.0 20 243

Index Scan using _accrged637_byperiod_trnrn on _accrged637 t8 (cost=0.06..3.07 rows=1 width=69) (actual time=0.005..0.145 rows=20 loops=243)

  • Index Cond: ((t8._period >= '2019-04-12 00:00:00'::timestamp without time zone) AND (t8._period <= '2019-04-12 23:59:59'::timestamp without time zone) AND (t8._kindrref = '\\200\\226\\310\\357\\267\\312\\036YB|\\210\\271\\363\\336O\\024'::bytea) AND (t8._correspond = '1'::numeric))
  • Filter: ((t8._value_type = '\\010'::bytea) AND (t8._value_rtref = '\\000\\000\\000\\026'::bytea) AND (t8._value_rrref = '\\332\\222\\000\\014)&\\343I\\021\\345 \\220l\\267\\032H'::bytea))
  • Buffers: shared hit=5495 read=7
14. 0.900 6,952.105 ↓ 1,887.0 1,887 1

Subquery Scan on *SELECT* 4 (cost=0.1..6.15 rows=1 width=230) (actual time=0.103..6,952.105 rows=1,887 loops=1)

  • Buffers: shared hit=994386 read=670
15. 685.788 6,951.205 ↓ 1,887.0 1,887 1

Nested Loop (cost=0.1..6.14 rows=1 width=182) (actual time=0.101..6,951.205 rows=1,887 loops=1)

  • Buffers: shared hit=994386 read=670
16. 13.819 13.819 ↓ 3,526.0 3,526 1

Index Scan using _accrg601_byperiod_trn on _accrg601 t9 (cost=0.04..3.06 rows=1 width=63) (actual time=0.047..13.819 rows=3,526 loops=1)

  • Index Cond: ((t9._period > '2019-04-12 23:59:59'::timestamp without time zone) AND (t9._period < '2019-05-01 00:00:00'::timestamp without time zone))
  • Filter: (t9._active AND (t9._accountdtrref <> '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) AND (t9._fld602rref = '\\226\\331\\000\\014nF\\374\\255\\021\\335<H\\371f\\000\\014'::bytea))
  • Buffers: shared hit=270 read=354
17. 6,251.598 6,251.598 ↓ 1,382.0 1,382 3,526

Index Scan using _accrged637_byperiod_trnrn on _accrged637 t10 (cost=0.06..3.07 rows=1 width=69) (actual time=0.015..1.773 rows=1,382 loops=3,526)

  • Index Cond: ((t10._period > '2019-04-12 23:59:59'::timestamp without time zone) AND (t10._period < '2019-05-01 00:00:00'::timestamp without time zone) AND (t10._kindrref = '\\200\\226\\310\\357\\267\\312\\036YB|\\210\\271\\363\\336O\\024'::bytea) AND (t10._correspond = '0'::numeric))
  • Filter: ((t10._value_type = '\\010'::bytea) AND (t10._value_rtref = '\\000\\000\\000\\026'::bytea) AND (t10._value_rrref = '\\332\\222\\000\\014)&\\343I\\021\\345 \\220l\\267\\032H'::bytea))
  • Buffers: shared hit=994116 read=316
18. 0.194 6,504.524 ↓ 470.0 470 1

Subquery Scan on *SELECT* 5 (cost=0.1..6.15 rows=1 width=230) (actual time=12.396..6,504.524 rows=470 loops=1)

  • Buffers: shared hit=761153 read=31
19. 200.474 6,504.330 ↓ 470.0 470 1

Nested Loop (cost=0.1..6.14 rows=1 width=182) (actual time=12.394..6,504.33 rows=470 loops=1)

  • Buffers: shared hit=761153 read=31
20. 6.420 6.420 ↓ 3,526.0 3,526 1

Index Scan using _accrg601_byperiod_trn on _accrg601 t11 (cost=0.04..3.06 rows=1 width=63) (actual time=0.039..6.42 rows=3,526 loops=1)

  • Index Cond: ((t11._period > '2019-04-12 23:59:59'::timestamp without time zone) AND (t11._period < '2019-05-01 00:00:00'::timestamp without time zone))
  • Filter: (t11._active AND (t11._accountctrref <> '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) AND (t11._fld602rref = '\\226\\331\\000\\014nF\\374\\255\\021\\335<H\\371f\\000\\014'::bytea))
  • Buffers: shared hit=624
21. 6,297.436 6,297.436 ↓ 439.0 439 3,526

Index Scan using _accrged637_byperiod_trnrn on _accrged637 t12 (cost=0.06..3.07 rows=1 width=69) (actual time=0.015..1.786 rows=439 loops=3,526)

  • Index Cond: ((t12._period > '2019-04-12 23:59:59'::timestamp without time zone) AND (t12._period < '2019-05-01 00:00:00'::timestamp without time zone) AND (t12._kindrref = '\\200\\226\\310\\357\\267\\312\\036YB|\\210\\271\\363\\336O\\024'::bytea) AND (t12._correspond = '1'::numeric))
  • Filter: ((t12._value_type = '\\010'::bytea) AND (t12._value_rtref = '\\000\\000\\000\\026'::bytea) AND (t12._value_rrref = '\\332\\222\\000\\014)&\\343I\\021\\345 \\220l\\267\\032H'::bytea))
  • Buffers: shared hit=760529 read=31