explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8rU1

Settings
# exclusive inclusive rows x rows loops node
1. 0.715 294.853 ↓ 292.0 292 1

Nested Loop (cost=0.00..55,574.28 rows=1 width=8) (actual time=0.092..294.853 rows=292 loops=1)

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

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

  • Filter: (id_registry <> 0)
  • Rows Removed by Filter: 648315
3. 0.500 0.500 ↓ 1.8 16 100

Seq Scan on op_registry org (cost=0.00..1.09 rows=9 width=4) (actual time=0.003..0.005 rows=16 loops=100)

Planning time : 0.271 ms
Execution time : 294.928 ms