explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dhs1

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 216.237 ↑ 1.0 1 1

Limit (cost=0.00..1.77 rows=1 width=65) (actual time=216.236..216.237 rows=1 loops=1)

2. 216.234 216.234 ↑ 670,181.0 1 1

Seq Scan on actions (cost=0.00..1,188,220.46 rows=670,181 width=65) (actual time=216.234..216.234 rows=1 loops=1)

  • Filter: ((service_id = 13) AND (provider_id = 1))
  • Rows Removed by Filter: 781034
Planning time : 0.149 ms
Execution time : 216.284 ms