explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8HC8

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 0.062 ↑ 1.0 1 1

Hash Join (cost=1.48..3.71 rows=1 width=64) (actual time=0.059..0.062 rows=1 loops=1)

2. 0.026 0.026 ↑ 1.0 1 1

Index Scan using ix_import_vn_observers_json_id_universal on import_vn.observers_json usr (cost=0.28..2.50 rows=1 width=1,502) (actual time=0.024..0.026 rows=1 loops=1)

3. 0.021 0.021 ↑ 1.0 8 1

Hash (cost=1.10..1.10 rows=8 width=388) (actual time=0.021..0.021 rows=8 loops=1)

4. 0.012 0.012 ↑ 1.0 8 1

Seq Scan on import_vn.entities_json ent (cost=0.00..1.10 rows=8 width=388) (actual time=0.010..0.012 rows=8 loops=1)

Planning time : 0.232 ms
Execution time : 0.102 ms