explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yZ6o

Settings
# exclusive inclusive rows x rows loops node
1. 2,567.207 2,567.207 ↑ 1.0 23,755 1

Index Scan using index_services_on_type on services (cost=0.56..16,579.26 rows=24,649 width=4) (actual time=1.424..2,567.207 rows=23,755 loops=1)

  • Index Cond: ((type)::text = 'JiraService'::text)
  • Buffers: shared hit=7008 read=10311
  • I/O Timings: read=2442.775
Planning time : 0.118 ms
Execution time : 2,569.043 ms