explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aG4O

Settings
# exclusive inclusive rows x rows loops node
1. 1.441 4.627 ↑ 1.1 2,291 1

Hash Join (cost=223.61..473.33 rows=2,613 width=39) (actual time=1.244..4.627 rows=2,291 loops=1)

  • Hash Cond: (entities.e_id = nlm.nl_e_id)
2. 1.969 1.969 ↑ 1.0 8,426 1

Seq Scan on entities (cost=0.00..178.93 rows=8,426 width=7) (actual time=0.014..1.969 rows=8,426 loops=1)

  • Filter: (e_et_code = ANY ('{VMTR,TAG,PSD}'::text[]))
  • Rows Removed by Filter: 878
3. 0.417 1.217 ↑ 1.0 2,885 1

Hash (cost=187.55..187.55 rows=2,885 width=8) (actual time=1.217..1.217 rows=2,885 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 145kB
4. 0.800 0.800 ↑ 1.0 2,885 1

Index Scan using nl_index_isactive on nodeslogical nlm (cost=0.28..187.55 rows=2,885 width=8) (actual time=0.011..0.800 rows=2,885 loops=1)