explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HH8X

Settings
# exclusive inclusive rows x rows loops node
1. 10,038.626 10,038.626 ↓ 105.5 404,394 1

Seq Scan on tb_contract c (cost=0.00..561,242.93 rows=3,832 width=753) (actual time=1.102..10,038.626 rows=404,394 loops=1)

  • Filter: (((status)::numeric = '0'::numeric) AND CASE WHEN (NULLIF((contract_data -> 'motivo_baixa'::text), ''::text) IS NULL) THEN true WHEN (NULLIF((contract_data -> 'motivo_baixa'::text), '""'::text) IS NULL) THEN true ELSE false END)
  • Rows Removed by Filter: 1094775
Planning time : 0.803 ms
Execution time : 10,770.756 ms