explain.depesz.com

PostgreSQL's explain analyze made readable

Result: e9E4

Settings
# exclusive inclusive rows x rows loops node
1. 0.372 340.428 ↓ 100.0 100 1

Nested Loop Semi Join (cost=0.00..55,574.35 rows=1 width=8) (actual time=0.150..340.428 rows=100 loops=1)

  • Join Filter: (oc.id_mo = org.id_mo)
  • Rows Removed by Join Filter: 1113
2. 339.856 339.856 ↓ 100.0 100 1

Seq Scan on op_case oc (cost=0.00..55,573.07 rows=1 width=12) (actual time=0.115..339.856 rows=100 loops=1)

  • Filter: (id_registry <> 0)
  • Rows Removed by Filter: 648316
3. 0.179 0.200 ↓ 1.3 12 100

Materialize (cost=0.00..1.14 rows=9 width=4) (actual time=0.001..0.002 rows=12 loops=100)

4. 0.021 0.021 ↓ 1.8 16 1

Seq Scan on op_registry org (cost=0.00..1.09 rows=9 width=4) (actual time=0.014..0.021 rows=16 loops=1)

Planning time : 0.465 ms
Execution time : 340.543 ms