explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k1Ox

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.179 ↑ 1.0 4 1

Limit (cost=0.42..2.69 rows=4 width=1,157) (actual time=0.108..0.179 rows=4 loops=1)

2. 0.027 0.176 ↑ 194,155.5 4 1

Nested Loop (cost=0.42..440,701.30 rows=776,622 width=1,157) (actual time=0.107..0.176 rows=4 loops=1)

3. 0.009 0.009 ↑ 194,155.5 4 1

Seq Scan on "Proposal" p (cost=0.00..85,377.22 rows=776,622 width=799) (actual time=0.009..0.009 rows=4 loops=1)

4. 0.140 0.140 ↑ 1.0 1 4

Index Scan using "ProposalBase_pkey" on "ProposalBase" pb (cost=0.42..0.46 rows=1 width=358) (actual time=0.035..0.035 rows=1 loops=4)

  • Index Cond: ((dealership_id = p.dealership_id) AND (proposal_base_id = p.proposal_base_id))
Planning time : 4.672 ms
Execution time : 0.362 ms