explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n54e

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.033 ↑ 3.0 1 1

Nested Loop (cost=0.15..20.69 rows=3 width=428) (actual time=0.032..0.033 rows=1 loops=1)

2. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on nodepool p (cost=0.00..12.50 rows=1 width=364) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (cluster_id = 'ajw-whoopthereitis:ec8691b6-a755-4e05-a82a-2d095f4e5c5c:us-west-2'::text)
3. 0.019 0.019 ↑ 1.0 1 1

Index Scan using awsnodepool_nodepool_id_key on awsnodepool aws (cost=0.15..8.17 rows=1 width=96) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: (nodepool_id = p.nodepool_id)
Planning time : 0.132 ms
Execution time : 0.065 ms