explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CnxH

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 19.795 ↓ 0.0 0 1

Limit (cost=0.57..6.40 rows=1 width=24) (actual time=19.795..19.795 rows=0 loops=1)

2. 0.001 19.795 ↓ 0.0 0 1

Subquery Scan on t1 (cost=0.57..6.40 rows=1 width=24) (actual time=19.795..19.795 rows=0 loops=1)

3. 0.000 19.794 ↓ 0.0 0 1

GroupAggregate (cost=0.57..6.39 rows=1 width=120) (actual time=19.794..19.794 rows=0 loops=1)

  • Group Key: t2._fld2970_type, t2._fld2970_rtref, t2._fld2970_rrref
  • Filter: ((sum(t2._fld2975) > (sum(t2._fld2979) + sum(t2._fld3192))) AND ((sum(t2._fld2975) <> '0'::numeric) OR (sum(t2._fld3192) <> '0'::numeric) OR (sum(t2._f
4. 19.794 19.794 ↓ 0.0 0 1

Index Scan using _accumrgtn2987_2 on _accumrgtn2987 t2 (cost=0.57..6.34 rows=1 width=33) (actual time=19.794..19.794 rows=0 loops=1)

  • Index Cond: ((_fld2970_type = '\x5c303130'::bytea) AND (_fld2970_rtref = '\x5c3030305c3030305c3030305b'::bytea))
  • Filter: ((_fld2975 <> '0'::numeric) OR (_fld3192 <> '0'::numeric) OR (_fld2979 <> '0'::numeric))
Planning time : 0.180 ms
Execution time : 19.835 ms