explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fZyMr

Settings
# exclusive inclusive rows x rows loops node
1. 154.216 154.216 ↑ 1.4 52,201 1

Index Scan using performance_inspection_completed_at_b5d1e961 on performance_inspection (cost=0.42..11,427.38 rows=73,530 width=37) (actual time=0.021..154.216 rows=52,201 loops=1)

  • Index Cond: ((completed_at >= '2020-01-08'::date) AND (completed_at <= '2020-09-07'::date))
  • Filter: ((shared_orgs && '{252437,300457,300456,300455,294164,252438,309926,309925,309238,309237,252440,252439,304641,305199,305196,293416,305292,305291,308693,308692,305207,305200,293415,293414,301157,305136,305197}'::integer[]) AND ((status)::text = 'completed'::text))
  • Rows Removed by Filter: 80,054