explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zQZD

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 1.021 ↑ 1.0 10 1

Limit (cost=0.00..12.98 rows=10 width=276) (actual time=0.108..1.021 rows=10 loops=1)

2. 1.015 1.015 ↑ 17,489.9 10 1

Seq Scan on t_policy_document this_ (cost=0.00..227,064.06 rows=174,899 width=276) (actual time=0.107..1.015 rows=10 loops=1)

  • Filter: ((((product_offering_code)::text <> 'PB'::text) OR (product_offering_code IS NULL)) AND (retry_count <= 1) AND (child_processor_id = 0) AND (sub_child_id = 1) AND (status = 2))
  • Rows Removed by Filter: 8514
Planning time : 0.175 ms
Execution time : 1.056 ms