explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pb81

Settings
# exclusive inclusive rows x rows loops node
1. 12,517.507 12,517.507 ↓ 0.0 0 1

Seq Scan on tb_contract c (cost=0.00..584,234.34 rows=1,277 width=753) (actual time=12,517.507..12,517.507 rows=0 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 AND (((contract_data -> 'data_geracao'::text))::date > ('now'::cstring)::date))
  • Rows Removed by Filter: 1499169
Planning time : 0.142 ms
Execution time : 12,518.541 ms