explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rSFn

Settings
# exclusive inclusive rows x rows loops node
1. 0.605 7.031 ↓ 126.0 126 1

Seq Scan on cliente_chat (cost=0.00..25.53 rows=1 width=524) (actual time=0.091..7.031 rows=126 loops=1)

  • Filter: ((id % '2'::bigint) = 0)
  • Rows Removed by Filter: 120
2.          

SubPlan (for Seq Scan)

3. 6.426 6.426 ↑ 1.0 1 126

Seq Scan on cliente_app (cost=0.00..3.84 rows=1 width=23) (actual time=0.020..0.051 rows=1 loops=126)

  • Filter: (fk_cen_usuario = cliente_chat.fk_cen_usuario)
  • Rows Removed by Filter: 146
Planning time : 0.146 ms
Execution time : 7.082 ms