explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QJTA : Optimization for: plan #RIOj

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.005 0.090 ↑ 1.0 1 1

Limit (cost=178.05..179.83 rows=1 width=18) (actual time=0.089..0.090 rows=1 loops=1)

2. 0.085 0.085 ↑ 4.3 101 1

Index Scan using attributemap_upload_idx on attributemap (cost=0.42..771.35 rows=434 width=18) (actual time=0.019..0.085 rows=101 loops=1)

  • Index Cond: ((destination = 'default_log_store'::text) AND (uploaded = false))
Planning time : 0.104 ms
Execution time : 0.100 ms