explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vfDLo

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.020 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.55..4.59 rows=1 width=91) (actual time=0.020..0.020 rows=0 loops=1)

2. 0.019 0.019 ↓ 0.0 0 1

Index Scan using dr_snapshot_block_id_idx on dr_snapshot disasterre0_ (cost=0.27..2.29 rows=1 width=33) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: (block_id = 1)
3. 0.000 0.000 ↓ 0.0 0

Index Scan using block_pkey on block block1_ (cost=0.28..2.29 rows=1 width=58) (never executed)

  • Index Cond: (id = 1)