explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ksbj : Bizarre choice

Settings
# exclusive inclusive rows x rows loops node
1. 0.322 451,715.042 ↑ 5.4 129 1

Limit (cost=0.43..4,365.28 rows=700 width=26) (actual time=429,365.354..451,715.042 rows=129 loops=1)

  • Buffers: shared hit=19,889,006 dirtied=5
2. 451,714.720 451,714.720 ↑ 4,576.9 129 1

Index Scan using pk_object_item__work_patterns on object_item__work_patterns t_0 (cost=0.43..3,681,519.07 rows=590,414 width=26) (actual time=429,365.350..451,714.720 rows=129 loops=1)

  • Filter: ((creation_date > '2019-12-30 00:00:00+01'::timestamp with time zone) AND ((object_type_id)::text = 'wi:traitement'::text) AND ((object_type_partition)::text = 'work_patterns'::text) AND ((properties -> 'nvlt:status'::text) = 'COMPLETED'::text) AND ((((properties -> 'rncs:temoinFacturation'::text))::boolean IS NULL) OR (NOT ((properties -> 'rncs:temoinFacturation'::text))::boolean)))
  • Rows Removed by Filter: 10,629,888
  • Buffers: shared hit=19,889,006 dirtied=5
Planning time : 1.026 ms
Execution time : 451,715.332 ms