explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QbWr

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 110.542 ↑ 1.0 1 1

Result (cost=3.04..3.05 rows=1 width=4) (actual time=110.541..110.542 rows=1 loops=1)

  • Buffers: shared hit=141 read=85 dirtied=8
  • I/O Timings: read=94.059
2.          

Initplan (for Result)

3. 0.002 110.535 ↑ 1.0 1 1

Limit (cost=0.29..3.04 rows=1 width=4) (actual time=110.535..110.535 rows=1 loops=1)

  • Buffers: shared hit=141 read=85 dirtied=8
  • I/O Timings: read=94.059
4. 110.533 110.533 ↑ 255.0 1 1

Index Scan using index_path_locks_on_user_id on public.path_locks (cost=0.29..701.80 rows=255 width=4) (actual time=110.532..110.533 rows=1 loops=1)

  • Index Cond: (path_locks.user_id IS NOT NULL)
  • Filter: ((path_locks.created_at >= '2020-08-12 05:57:35.090067'::timestamp without time zone) AND (path_locks.created_at <= '2020-09-09 05:57:35.090149'::timestamp without time zone))
  • Rows Removed by Filter: 237
  • Buffers: shared hit=141 read=85 dirtied=8
  • I/O Timings: read=94.059