explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PYQs

Settings
# exclusive inclusive rows x rows loops node
1. 2.198 118.949 ↑ 1.0 1 1

Aggregate (cost=16,640.88..16,640.89 rows=1 width=8) (actual time=118.948..118.949 rows=1 loops=1)

  • Buffers: shared hit=17319
2. 116.751 116.751 ↑ 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=0.122..116.751 rows=23,755 loops=1)

  • Index Cond: ((type)::text = 'JiraService'::text)
  • Buffers: shared hit=17319
Planning time : 0.598 ms
Execution time : 119.013 ms