explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9nik

Settings
# exclusive inclusive rows x rows loops node
1. 8.834 8.871 ↑ 1.0 1 1

Hash Join (cost=17.42..1,009.40 rows=1 width=25) (actual time=6.705..8.871 rows=1 loops=1)

  • Hash Cond: (opl.id_operation_parameter_group_local = opgl.id)
  • -> Seq Scan on operation_parameter_local opl (cost=0.00..987.48 rows=1715 width=25) (actual time=3.502..8.238 r
  • Filter: ((key)::text = 'val.res.perfil'::text)
  • Rows Removed by Filter: 30151
2. 0.037 0.037 ↑ 1.0 1 1

Hash (cost=17.41..17.41 rows=1 width=8) (actual time=0.036..0.037 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • -> Bitmap Heap Scan on operating_parameter_group_local opgl (cost=4.31..17.41 rows=1 width=8) (actual tim
  • Recheck Cond: (tgn = 1051)
  • Filter: is_last_version
  • Rows Removed by Filter: 10
  • Heap Blocks: exact=2
  • -> Bitmap Index Scan on ind_02_operating_parameter_group_local (cost=0.00..4.31 rows=4 width=0) (ac
  • Index Cond: (tgn = 1051)
Planning time : 0.773 ms
Execution time : 8.940 ms