explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TRfW

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.069 ↓ 0.0 0 1

Limit (cost=37.46..37.47 rows=1 width=42) (actual time=0.069..0.069 rows=0 loops=1)

2. 0.018 0.068 ↓ 0.0 0 1

Sort (cost=37.46..37.47 rows=1 width=42) (actual time=0.068..0.068 rows=0 loops=1)

  • Sort Key: t1._fld68376rref
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.050 ↓ 0.0 0 1

Nested Loop (cost=24.21..37.40 rows=1 width=42) (actual time=0.050..0.050 rows=0 loops=1)

4. 0.001 0.050 ↓ 0.0 0 1

HashAggregate (cost=23.53..23.54 rows=1 width=100) (actual time=0.050..0.050 rows=0 loops=1)

  • Group Key: t2._fld74574_rrref, t2._fld74575_rrref, t2._fld74576_rrref, t2._fld74577_rrref, t2._fld74578_rrref, t2._fld74578_rrref
5. 0.001 0.049 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.66..23.52 rows=1 width=100) (actual time=0.049..0.049 rows=0 loops=1)

  • Filter: ((t3._fld76832rref IS NOT NULL) OR (t4._fld76832rref IS NOT NULL))
6. 0.000 0.048 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.10..14.93 rows=1 width=140) (actual time=0.048..0.048 rows=0 loops=1)

7. 0.048 0.048 ↓ 0.0 0 1

Index Scan using _inforg74571_1 on _inforg74571 t2 (cost=0.55..6.35 rows=1 width=120) (actual time=0.048..0.048 rows=0 loops=1)

  • Index Cond: ((_fld1389 = '0'::numeric) AND (_fld74572_type = '\x5c303130'::bytea) AND (_fld74572_rtref = '\x5c3030305c3030305c3030305c323331'::bytea) AND (_fld74572_rrref = '\x5c3230305c3333325c30303050565c3231335c3033365c3234325c3032315c333435775c333032305c323435685c323633'::bytea) AND (_fld74573 = false) AND (_fld74574_type = '\x5c303130'::bytea) AND (_fld74574_rtref = '\x5c3030305c3030305c3030305c323331'::bytea) AND (_fld74575_type = '\x5c303130'::bytea) AND (_fld74575_rtref = '\x5c3030305c3030305c3030305c333237'::bytea) AND (_fld74576_type = '\x5c303130'::bytea) AND (_fld74576_rtref = '\x5c3030305c3030305c3030305c333630'::bytea) AND (_fld74577_type = '\x5c303130'::bytea) AND (_fld74577_rtref = '\x5c3030305c3030305c3337326e'::bytea))
  • Filter: ((NOT _fld74573) AND (_fld74578_type = '\x5c303130'::bytea) AND (_fld74578_rtref = '\x5c3030305c3030305c30303179'::bytea))
8. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg76830_2 on _inforg76830 t3 (cost=0.56..8.58 rows=1 width=20) (never executed)

  • Index Cond: ((_fld1389 = '0'::numeric) AND (_fld76832rref = t2._fld74579rref) AND (_fld76831rref = '\x5c3230375c3234332c5c3337355c3234315c3237373d5c3231305c3032315c3335305c333135345c3335355c3234307e47'::bytea))
  • Heap Fetches: 0
9. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg76830_2 on _inforg76830 t4 (cost=0.56..8.58 rows=1 width=20) (never executed)

  • Index Cond: ((_fld1389 = '0'::numeric) AND (_fld76832rref = t2._fld74579rref) AND (_fld76831rref = '\x5c3230375c3230375c3236306e5c3237375c3237375c3031305c3330375c3032315c3335305c3234315c3033355c3236355c3237345b29'::bytea))
  • Heap Fetches: 0
10. 0.000 0.000 ↓ 0.0 0

Index Scan using _inforg68375_2 on _inforg68375 t1 (cost=0.68..13.85 rows=1 width=122) (never executed)

  • Index Cond: ((_fld1389 = '0'::numeric) AND (_fld68380rref = t2._fld74577_rrref) AND (_fld68376rref = t2._fld74574_rrref) AND (_fld68378rref = t2._fld74575_rrref) AND (_fld68379rref = t2._fld74576_rrref) AND (_fld68382rref = t2._fld74578_rrref))