explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TKklo

Settings
# exclusive inclusive rows x rows loops node
1. 0.052 0.191 ↓ 0.0 0 1

Sort (cost=79,896.32..79,900.54 rows=1,689 width=155) (actual time=0.191..0.191 rows=0 loops=1)

  • Sort Key: t4._fld787_type, t4._fld787_n, t4._fld787_s, t8._code, t6._enumorder, t7._enumorder
  • Sort Method: quicksort Memory: 25kB
2. 0.000 0.139 ↓ 0.0 0 1

Nested Loop Left Join (cost=68,497.25..79,805.77 rows=1,689 width=155) (actual time=0.139..0.139 rows=0 loops=1)

3. 0.001 0.139 ↓ 0.0 0 1

Hash Left Join (cost=68,496.83..70,823.05 rows=1,689 width=149) (actual time=0.139..0.139 rows=0 loops=1)

  • Hash Cond: (t1.fld3006rref = t7._idrref)
4. 0.000 0.138 ↓ 0.0 0 1

Hash Left Join (cost=68,494.76..70,816.46 rows=1,689 width=145) (actual time=0.138..0.138 rows=0 loops=1)

  • Hash Cond: (t5._fld738rref = t6._idrref)
5. 0.000 0.138 ↓ 0.0 0 1

Hash Left Join (cost=68,492.58..70,807.76 rows=1,689 width=141) (actual time=0.138..0.138 rows=0 loops=1)

  • Hash Cond: (t4._fld784rref = t5._idrref)
6. 0.011 0.138 ↓ 0.0 0 1

Merge Right Join (cost=68,487.41..70,797.80 rows=1,689 width=143) (actual time=0.138..0.138 rows=0 loops=1)

  • Merge Cond: (t4._idrref = t1.fld3001rref)
  • -> Index Scan using _reference85_pkey on _reference85 t4 (cost=0.29..2238.16 rows=18,873 width=45) (actual time=0.009..0.009 rows=1 loops=
7. 0.011 0.127 ↓ 0.0 0 1

Sort (cost=68,487.13..68,491.35 rows=1,689 width=115) (actual time=0.127..0.127 rows=0 loops=1)

  • Sort Key: t1.fld3001rref
  • Sort Method: quicksort Memory: 25kB
8. 0.000 0.116 ↓ 0.0 0 1

Subquery Scan on t1 (cost=68,333.24..68,396.58 rows=1,689 width=115) (actual time=0.116..0.116 rows=0 loops=1)

9. 0.007 0.116 ↓ 0.0 0 1

HashAggregate (cost=68,333.24..68,379.69 rows=1,689 width=179) (actual time=0.116..0.116 rows=0 loops=1)

  • Group Key: t3._fld3001rref, t3._fld3006rref, t3._fld3007rref
  • Filter: ((sum((((sum('0'::numeric)) + (sum(CASE WHEN (t3._recordkind = '0'::numeric) THEN t3._fld3011 ELSE '0'::numeric $
10. 0.109 0.109 ↓ 0.0 0 1

HashAggregate (cost=67,066.19..67,488.54 rows=16,894 width=147) (actual time=0.109..0.109 rows=0 loops=1)

  • Group Key: t3._fld3001rref, t3._fld3006rref, t3._fld3007rref
  • Filter: ((sum('0'::numeric) <> '0'::numeric) OR (sum(CASE WHEN (t3._recordkind = '0'::numeric) THEN t3._fld3011 EL$
  • -> Bitmap Heap Scan on _accumrg3000 t3 (cost=837.97..66516.78 rows=16,905 width=60) (actual time=0.020..0.020 rows
  • Recheck Cond: ((_fld3007rref = '\x5c3230305c3331305c3031345c3330347a5c323136715c3330335c3032315c333437375c303
  • Filter: _active
  • -> Bitmap Index Scan on _accumrg3000_9 (cost=0.00..833.74 rows=16,905 width=0) (actual time=0.018..0.018 row
  • Index Cond: ((_fld3007rref = '\x5c3230305c3331305c3031345c3330347a5c323136715c3330335c3032315c333437375
11. 0.000 0.000 ↓ 0.0 0

Hash (cost=4.52..4.52 rows=52 width=34) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Seq Scan on _reference80 t5 (cost=0.00..4.52 rows=52 width=34) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.08..2.08 rows=8 width=21) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Seq Scan on _enum144 t6 (cost=0.00..2.08 rows=8 width=21) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.03..2.03 rows=3 width=21) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Seq Scan on _enum145 t7 (cost=0.00..2.03 rows=3 width=21) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Index Scan using _reference47ng_pkey1 on _reference47 t8 (cost=0.42..5.32 rows=1 width=23) (never executed)

  • Index Cond: (t1.fld3007rref = _idrref)
Planning time : 5.006 ms
Execution time : 0.968 ms