explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eOzB : Optimization for: plan #8HC8

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 0.052 ↑ 1.0 1 1

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

2. 0.018 0.018 ↑ 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.017..0.018 rows=1 loops=1)

3. 0.020 0.020 ↑ 1.0 8 1

Hash (cost=1.10..1.10 rows=8 width=388) (actual time=0.020..0.020 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.009..0.012 rows=8 loops=1)

Planning time : 0.356 ms
Execution time : 0.091 ms