explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gaz

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 82,891.796 ↑ 1.0 1 1

Limit (cost=0.44..18.16 rows=1 width=65) (actual time=82,891.795..82,891.796 rows=1 loops=1)

2. 82,891.793 82,891.793 ↑ 103,729.0 1 1

Index Scan Backward using actions_pkey on actions (cost=0.44..1,837,723.68 rows=103,729 width=65) (actual time=82,891.793..82,891.793 rows=1 loops=1)

  • Filter: ((service_id = 1) AND (provider_id = 1))
  • Rows Removed by Filter: 37660433
Planning time : 7.029 ms
Execution time : 82,891.913 ms