explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 23DJ

Settings
# exclusive inclusive rows x rows loops node
1. 48,242.470 48,242.470 ↓ 0.0 14,172,819 1

(cost=0.00..2192049.17 rows=14190764 width=754) (cost=0..0 rows=0 width=0) (actual time=3.944..48,242.470 rows=14,172,819 loops=1)

  • Filter: ((NOT projects.disable_overriding_approvers_per_merge_request) OR (projects.disable_overriding_approvers_per_merge_request IS NULL))
  • Rows Removed by Filter: 21,245
  • Buffers: shared read=512,535 dirtied=36,808 written=35,417
  • I/O Timings: read=21,094.811 write=3,874.451