explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z5gT

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 13.742 ↑ 1.0 1 1

Limit (cost=0.56..3.58 rows=1 width=80) (actual time=13.741..13.742 rows=1 loops=1)

  • Buffers: shared read=5
  • I/O Timings: read=13.681
2. 13.740 13.740 ↑ 1.0 1 1

Index Scan using index_routes_on_source_type_and_source_id on public.routes (cost=0.56..3.58 rows=1 width=80) (actual time=13.740..13.740 rows=1 loops=1)

  • Index Cond: (((routes.source_type)::text = 'Project'::text) AND (routes.source_id = 278,964))
  • Buffers: shared read=5
  • I/O Timings: read=13.681