explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LJbD

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.041 ↑ 1.0 1 1

Limit (cost=0.28..6.30 rows=1 width=274) (actual time=0.041..0.041 rows=1 loops=1)

  • -> Index Scan using ppcc_prospect_pkey on ppcc_prospect t1 (cost=0.28..6.30
2. 0.040 0.040 ↓ 0.0 1 1

rows=1 width=274) (cost=0..0 rows=0 width=0) (actual time=0.039..0.040 rows=1 loops=1)

  • Index Cond: (id = 5,493)
Planning time : 1.432 ms
Execution time : 0.109 ms