explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v7lc : Non-Working

Settings
# exclusive inclusive rows x rows loops node
1. 1.231 3.049 ↓ 0.0 0 1

Seq Scan on timepunchrevision timepunchrevision1 (cost=0.00..9,718.14 rows=1,357 width=16) (actual time=3.049..3.049 rows=0 loops=1)

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

SubPlan (for Seq Scan)

3. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (previousrevisionid = timepunchrevision1.id)
  • Heap Fetches: 0
4. 0.002 0.002 ↑ 262.4 8 1

Seq Scan on timepunchrevision timepunchrevision2_1 (cost=0.00..67.99 rows=2,099 width=16) (actual time=0.002..0.002 rows=8 loops=1)

  • Buffers: shared hit=1
5. 1.816 1.816 ↓ 0.0 0 1,816

Index Scan using timepunchrevision_uniquepreviousrevisionid on timepunchrevision timepunchrevision3 (cost=0.28..2.30 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=1,816)

  • Index Cond: (previousrevisionid = timepunchrevision1.id)
  • Filter: (fromtimestamputc <> timepunchrevision1.totimestamputc)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=5,430
Planning time : 0.136 ms
Execution time : 3.089 ms