explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9grk

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Finalize Aggregate (cost=3,934,579.87..3,934,579.88 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=3,934,579.66..3,934,579.87 rows=2 width=8) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=3,933,579.66..3,933,579.67 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on pr_data_ih_fact "PC0" (cost=0.00..3,828,586.25 rows=41,997,361 width=0) (actual rows= loops=)

  • Filter: ((pxoutcometime > '2020-08-08 08:32:17.675'::timestamp without time zone) AND (pzactionid = ANY ('{8283194409957875481,8911853707702066171,2673310211367396336,3791298285882915779,7259167151471797341,-7746204285810123798,-5462365562347727831,-1048327257334819657,-363231061652586669,1528193167165669655,8448797016519742771,-4418615791185374387,-8854685358570643542,-4120505149798977148,-6980901730719066716,7414095692951555919}'::numeric[])))