explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6ES

Settings
# exclusive inclusive rows x rows loops node
1. 0.043 707.726 ↑ 1.0 500 1

Limit (cost=0.56..78.76 rows=500 width=8) (actual time=646.673..707.726 rows=500 loops=1)

2. 707.683 707.683 ↑ 27,614.9 500 1

Index Scan using party_id on merchant_parties (cost=0.56..2,159,512.61 rows=13,807,431 width=8) (actual time=646.672..707.683 rows=500 loops=1)

  • Filter: (updated_at IS NULL)
  • Rows Removed by Filter: 1054900
Planning time : 0.112 ms
Execution time : 707.769 ms