explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LsVj

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,056,524,097.17..1,412,671,999,968,659.50 rows=125,569,943,507,061,872 width=16) (actual rows= loops=)

  • Hash Cond: (cleb.id = citem.cle_id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on okc_k_lines_b cleb (cost=0.00..72,509,747.44 rows=436,777,869 width=16) (actual rows= loops=)

  • Filter: (lse_id = ANY ('{3,16,21}'::double precision[]))
3. 0.000 0.000 ↓ 0.0

Hash (cost=51,807,438.88..51,807,438.88 rows=287,491,543 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on okc_k_items citem (cost=0.00..51,807,438.88 rows=287,491,543 width=8) (actual rows= loops=)

  • Filter: (((jtot_object1_code)::text = 'OKX_BUSIPROC'::text) AND ((object1_id2)::text = '#'::text))