explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YXgU : without indexes

Settings
# exclusive inclusive rows x rows loops node
1. 6.044 2,258,943.182 ↑ 145.2 429 1

Gather (cost=1,000.00..19,046,281.70 rows=62,292 width=1,686) (actual time=668,767.813..2,258,943.182 rows=429 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 2,258,937.138 2,258,937.138 ↑ 181.5 143 3 / 3

Parallel Seq Scan on cover1596101403432 (cost=0.00..19,039,052.50 rows=25,955 width=1,686) (actual time=668,769.171..2,258,937.138 rows=143 loops=3)

  • Filter: ((('(120001800,214480801)'::record IS NULL) OR ((policy_id)::text = ANY ('{120001800,214480801}'::text[]))) AND (('(CBNL,HERM)'::record IS NULL) OR ((policy_bu_code)::text = ANY ('{CBNL,HERM}'::text[]))))
  • Rows Removed by Filter: 27,134,551