explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xYUJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 268.684 ↑ 5.0 1 1

Nested Loop (cost=0.03..5,311.09 rows=5 width=128) (actual time=268.681..268.684 rows=1 loops=1)

  • Buffers: shared hit=50009 read=11991
2. 0.036 0.036 ↑ 1.0 1 1

Index Scan using _reference22_pkey on _reference22 t13 (cost=0.03..0.84 rows=1 width=40) (actual time=0.034..0.036 rows=1 loops=1)

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

Aggregate (cost=0..5,310.14 rows=5 width=286) (actual time=268.636..268.636 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=50006 read=11991
4. 0.591 264.708 ↓ 699.2 3,496 1

Append (cost=0..5,310 rows=5 width=212) (actual time=0.792..264.708 rows=3,496 loops=1)

  • Buffers: shared hit=50006 read=11991
5. 183.634 183.634 ↓ 239.0 239 1

Seq Scan on _accrgat2634 t3 (cost=0..5,299.66 rows=1 width=202) (actual time=0.791..183.634 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 hit=64 read=11991
6. 0.016 0.594 ↓ 56.0 56 1

Subquery Scan on *SELECT* 2 (cost=0.1..3.42 rows=1 width=178) (actual time=0.204..0.594 rows=56 loops=1)

  • Buffers: shared hit=248
7. 0.110 0.578 ↓ 56.0 56 1

Nested Loop (cost=0.1..3.41 rows=1 width=158) (actual time=0.202..0.578 rows=56 loops=1)

  • Buffers: shared hit=248
8. 0.188 0.188 ↓ 56.0 56 1

Index Scan using _accrged637_byextdim_rt on _accrged637 t6 (cost=0.06..2.54 rows=1 width=69) (actual time=0.148..0.188 rows=56 loops=1)

  • Index Cond: ((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) AND (t6._period >= '2019-04-01 00:00:00'::timestamp without time zone) AND (t6._period <= '2019-04-01 23:59:59'::timestamp without time zone))
  • Filter: ((t6._correspond = '0'::numeric) AND (t6._kindrref = '\\200\\226\\310\\357\\267\\312\\036YB|\\210\\271\\363\\336O\\024'::bytea))
  • Buffers: shared hit=23
9. 0.280 0.280 ↑ 1.0 1 56

Index Scan using _accrg601_byrecorder_rn on _accrg601 t5 (cost=0.04..0.86 rows=1 width=63) (actual time=0.005..0.005 rows=1 loops=56)

  • Index Cond: ((t5._recordertref = t6._recordertref) AND (t5._recorderrref = t6._recorderrref) AND (t5._lineno = t6._lineno))
  • 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._period >= '2019-04-01 00:00:00'::timestamp without time zone) AND (t5._period <= '2019-04-01 23:59:59'::timestamp without time zone) AND (t5._fld602rref = '\\226\\331\\000\\014nF\\374\\255\\021\\335<H\\371f\\000\\014'::bytea) AND (t6._period = t5._period))
  • Buffers: shared hit=225
10. 0.012 0.484 ↓ 44.0 44 1

Subquery Scan on *SELECT* 3 (cost=0.1..3.42 rows=1 width=218) (actual time=0.118..0.484 rows=44 loops=1)

  • Buffers: shared hit=199
11. 0.070 0.472 ↓ 44.0 44 1

Nested Loop (cost=0.1..3.41 rows=1 width=198) (actual time=0.116..0.472 rows=44 loops=1)

  • Buffers: shared hit=199
12. 0.138 0.138 ↓ 44.0 44 1

Index Scan using _accrged637_byextdim_rt on _accrged637 t8 (cost=0.06..2.54 rows=1 width=69) (actual time=0.05..0.138 rows=44 loops=1)

  • Index Cond: ((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) AND (t8._period >= '2019-04-01 00:00:00'::timestamp without time zone) AND (t8._period <= '2019-04-01 23:59:59'::timestamp without time zone))
  • Filter: ((t8._correspond = '1'::numeric) AND (t8._kindrref = '\\200\\226\\310\\357\\267\\312\\036YB|\\210\\271\\363\\336O\\024'::bytea))
  • Buffers: shared hit=23
13. 0.264 0.264 ↑ 1.0 1 44

Index Scan using _accrg601_byrecorder_rn on _accrg601 t7 (cost=0.04..0.86 rows=1 width=63) (actual time=0.006..0.006 rows=1 loops=44)

  • Index Cond: ((t7._recordertref = t8._recordertref) AND (t7._recorderrref = t8._recorderrref) AND (t7._lineno = t8._lineno))
  • 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._period >= '2019-04-01 00:00:00'::timestamp without time zone) AND (t7._period <= '2019-04-01 23:59:59'::timestamp without time zone) AND (t7._fld602rref = '\\226\\331\\000\\014nF\\374\\255\\021\\335<H\\371f\\000\\014'::bytea) AND (t8._period = t7._period))
  • Buffers: shared hit=176
14. 0.567 41.655 ↓ 2,432.0 2,432 1

Subquery Scan on *SELECT* 4 (cost=0.1..1.75 rows=1 width=230) (actual time=0.085..41.655 rows=2,432 loops=1)

  • Buffers: shared hit=24740
15. 4.526 41.088 ↓ 2,432.0 2,432 1

Nested Loop (cost=0.1..1.74 rows=1 width=182) (actual time=0.083..41.088 rows=2,432 loops=1)

  • Buffers: shared hit=24740
16. 3.403 3.403 ↓ 4,737.0 4,737 1

Index Scan using _accrg601_byperiod_trn on _accrg601 t9 (cost=0.04..0.86 rows=1 width=63) (actual time=0.028..3.403 rows=4,737 loops=1)

  • Index Cond: ((t9._period > '2019-04-01 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=910
17. 33.159 33.159 ↑ 1.0 1 4,737

Index Scan using _accrged637_byrecorder_rnn on _accrged637 t10 (cost=0.06..0.87 rows=1 width=69) (actual time=0.007..0.007 rows=1 loops=4,737)

  • Index Cond: ((t10._recordertref = t9._recordertref) AND (t10._recorderrref = t9._recorderrref) AND (t10._lineno = t9._lineno) AND (t10._correspond = '0'::numeric))
  • Filter: ((t10._period > '2019-04-01 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._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) AND (t9._period = t10._period))
  • Buffers: shared hit=23830
18. 0.203 37.750 ↓ 725.0 725 1

Subquery Scan on *SELECT* 5 (cost=0.1..1.75 rows=1 width=230) (actual time=0.137..37.75 rows=725 loops=1)

  • Buffers: shared hit=24755
19. 1.390 37.547 ↓ 725.0 725 1

Nested Loop (cost=0.1..1.74 rows=1 width=182) (actual time=0.136..37.547 rows=725 loops=1)

  • Buffers: shared hit=24755
20. 2.998 2.998 ↓ 4,737.0 4,737 1

Index Scan using _accrg601_byperiod_trn on _accrg601 t11 (cost=0.04..0.86 rows=1 width=63) (actual time=0.036..2.998 rows=4,737 loops=1)

  • Index Cond: ((t11._period > '2019-04-01 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=910
21. 33.159 33.159 ↓ 0.0 0 4,737

Index Scan using _accrged637_byrecorder_rnn on _accrged637 t12 (cost=0.06..0.87 rows=1 width=69) (actual time=0.007..0.007 rows=0 loops=4,737)

  • Index Cond: ((t12._recordertref = t11._recordertref) AND (t12._recorderrref = t11._recorderrref) AND (t12._lineno = t11._lineno) AND (t12._correspond = '1'::numeric))
  • Filter: ((t12._period > '2019-04-01 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._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) AND (t11._period = t12._period))
  • Buffers: shared hit=23845