explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Plw

Settings
# exclusive inclusive rows x rows loops node
1. 731.164 2,757.617 ↑ 1.0 1 1

Aggregate (cost=650,816.53..650,816.54 rows=1 width=0) (actual time=2,757.617..2,757.617 rows=1 loops=1)

2. 2,026.453 2,026.453 ↑ 1.0 1,482,736 1

Index Only Scan using index_ads_status_active on ads (cost=0.00..647,077.59 rows=1,495,576 width=0) (actual time=0.120..2,026.453 rows=1,482,736 loops=1)

  • Index Cond: (status = 'active'::text)
  • Heap Fetches: 1,521,393
Total runtime : 2,757.641 ms