explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BfcM

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.008 ↑ 27.3 3 1

Seq Scan on timepunchrevision timepunchrevision1 (cost=0.00..486.58 rows=82 width=16) (actual time=0.007..0.008 rows=3 loops=1)

  • Filter: ((totimestamputc IS NOT NULL) AND ((NOT (alternatives: SubPlan 1 or hashed SubPlan 2)) OR (SubPlan 3)))
  • Rows Removed by Filter: 4
  • Buffers: shared hit=2
2.          

SubPlan (for Seq Scan)

3. 0.000 0.000 ↓ 0.0 0

Index Only Scan using timepunchrevision_uniquepreviousrevisionid on timepunchrevision timepunchrevision2 (cost=0.14..2.16 rows=1 width=0) (never executed)

  • Index Cond: (previousrevisionid = timepunchrevision1.id)
  • Heap Fetches: 0
4. 0.001 0.001 ↑ 110.0 1 1

Seq Scan on timepunchrevision timepunchrevision2_1 (cost=0.00..11.10 rows=110 width=16) (actual time=0.001..0.001 rows=1 loops=1)

  • Buffers: shared hit=1
5. 0.000 0.000 ↓ 0.0 0

Index Scan using timepunchrevision_uniquepreviousrevisionid on timepunchrevision timepunchrevision3 (cost=0.14..2.16 rows=1 width=0) (never executed)

  • Index Cond: (previousrevisionid = timepunchrevision1.id)
  • Filter: (fromtimestamputc <> timepunchrevision1.totimestamputc)
Planning time : 0.121 ms