explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d5Wh

Settings
# exclusive inclusive rows x rows loops node
1. 50.554 3,241.425 ↑ 1.0 20 1

Limit (cost=2,262,450.22..2,262,455.37 rows=20 width=32) (actual time=3,063.162..3,241.425 rows=20 loops=1)

2. 0.000 3,190.871 ↑ 318,345.0 20 1

Group (cost=2,262,450.22..3,901,576.19 rows=6,366,900 width=32) (actual time=3,063.159..3,190.871 rows=20 loops=1)

  • Group Key: (jsonb_array_elements_text(("values" -> '2200000124944191'::text)))
3. 110.776 3,241.384 ↑ 219,548.3 58 1

Gather Merge (cost=2,262,450.22..3,837,907.19 rows=12,733,800 width=32) (actual time=3,063.157..3,241.384 rows=58 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 86.242 3,130.608 ↑ 172,078.4 37 3 / 3

Group (cost=2,261,450.19..2,367,110.69 rows=6,366,900 width=32) (actual time=2,940.929..3,130.608 rows=37 loops=3)

  • Group Key: (jsonb_array_elements_text(("values" -> '2200000124944191'::text)))
5. 1,803.629 3,044.366 ↑ 30.8 479,003 3 / 3

Sort (cost=2,261,450.19..2,298,363.19 rows=14,765,200 width=32) (actual time=2,940.926..3,044.366 rows=479,003 loops=3)

  • Sort Key: (jsonb_array_elements_text(("values" -> '2200000124944191'::text))) DESC NULLS LAST
  • Sort Method: quicksort Memory: 88,901kB
6. 1,027.365 1,240.737 ↑ 17.6 838,772 3 / 3

ProjectSet (cost=0.00..149,963.50 rows=14,765,200 width=32) (actual time=0.243..1,240.737 rows=838,772 loops=3)

7. 213.372 213.372 ↑ 1.2 119,289 3 / 3

Parallel Seq Scan on items_127 items (cost=0.00..74,660.98 rows=147,652 width=454) (actual time=0.183..213.372 rows=119,289 loops=3)

  • Filter: ((deleted_on IS NULL) AND (table_id = '2100000011828927'::bigint))
  • Rows Removed by Filter: 187,678
Planning time : 2.932 ms
Execution time : 3,251.764 ms