explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5bvr

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 262,192.445 ↓ 0.0 0 1

Limit (cost=1,000.59..22,746.29 rows=100 width=716) (actual time=262,192.445..262,192.445 rows=0 loops=1)

2. 632.640 262,807.373 ↓ 0.0 0 1

Gather Merge (cost=1,000.59..2,830,551.23 rows=13,012 width=716) (actual time=262,192.440..262,807.373 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 262,174.733 262,174.733 ↓ 0.0 0 3 / 3

Parallel Index Scan Backward using builds_pkey on builds (cost=0.56..2,828,049.29 rows=5,422 width=716) (actual time=262,174.733..262,174.733 rows=0 loops=3)

  • Filter: ((productid = 200) AND ((status)::text = 'succeeded'::text) AND (branchid = 644))
  • Rows Removed by Filter: 9,719,612
Planning time : 0.220 ms
Execution time : 262,807.425 ms