explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RKtc

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 4,359.518 ↑ 1.0 500 1

Limit (cost=0.56..99.63 rows=500 width=16) (actual time=4,358.992..4,359.518 rows=500 loops=1)

2. 4,359.481 4,359.481 ↑ 27,614.9 500 1

Index Scan using idx_merchant_parties_merchant_id on merchant_parties (cost=0.56..2,735,778.25 rows=13,807,431 width=16) (actual time=4,358.991..4,359.481 rows=500 loops=1)

  • Filter: (updated_at IS NULL)
  • Rows Removed by Filter: 6060004
Planning time : 0.091 ms
Execution time : 4,359.556 ms