explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5ytY

Settings
# exclusive inclusive rows x rows loops node
1. 1,830.361 3,676.668 ↑ 1.0 1 1

Aggregate (cost=15,911.30..15,911.31 rows=1 width=8) (actual time=3,676.661..3,676.668 rows=1 loops=1)

2. 1,846.307 1,846.307 ↑ 1.0 249,398 1

Index Only Scan using lucky on data (cost=0.42..15,284.13 rows=250,866 width=0) (actual time=0.068..1,846.307 rows=249,398 loops=1)

  • Index Cond: ((lucky_number > 500) AND (coin_flip = 'heads'::text))
  • Heap Fetches: 0