explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2Li6

Settings
# exclusive inclusive rows x rows loops node
1. 0.048 0.528 ↑ 1.0 500 1

Limit (cost=0.56..78.82 rows=500 width=8) (actual time=0.017..0.528 rows=500 loops=1)

2. 0.480 0.480 ↑ 27,592.2 500 1

Index Scan Backward using party_id on merchant_parties (cost=0.56..2,159,276.87 rows=13,796,094 width=8) (actual time=0.016..0.480 rows=500 loops=1)

  • Filter: (updated_at IS NULL)
  • Rows Removed by Filter: 8
Planning time : 0.285 ms
Execution time : 0.569 ms