explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j37l

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 3,856.087 ↑ 1.0 1 1

Aggregate (cost=200,443.95..200,443.96 rows=1 width=8) (actual time=3,856.086..3,856.087 rows=1 loops=1)

2. 0.049 3,856.051 ↑ 856.0 23 1

Nested Loop (cost=1,002.13..200,394.73 rows=19,688 width=0) (actual time=2,957.375..3,856.051 rows=23 loops=1)

3. 0.475 0.475 ↑ 1.0 1 1

Index Only Scan using pond_user_pkey on pond_user pu (cost=0.43..2.44 rows=1 width=4) (actual time=0.062..0.475 rows=1 loops=1)

  • Index Cond: (objectid = 614967)
  • Heap Fetches: 50
4. 12.142 3,855.527 ↑ 856.0 23 1

Gather (cost=1,001.71..200,195.41 rows=19,688 width=4) (actual time=2,957.307..3,855.527 rows=23 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 0.050 3,843.385 ↑ 1,025.4 8 3 / 3

Nested Loop (cost=1.71..197,226.61 rows=8,203 width=4) (actual time=3,441.760..3,843.385 rows=8 loops=3)

6. 96.427 3,840.552 ↑ 1,038.2 8 3 / 3

Nested Loop Anti Join (cost=1.14..130,987.79 rows=8,306 width=8) (actual time=3,441.443..3,840.552 rows=8 loops=3)

7. 3,497.699 3,497.699 ↓ 1.5 27,381 3 / 3

Parallel Index Scan using pond_item_common_x9r on pond_item_common pic (cost=0.57..103,783.39 rows=18,825 width=10) (actual time=0.442..3,497.699 rows=27,381 loops=3)

  • Index Cond: (pond_user = 614967)
  • Filter: ((video_standard < 800) AND (video_standard < 800) AND (status = 30) AND (status = ANY ('{7,8,9,10,30}'::integer[])))
  • Rows Removed by Filter: 35
8. 246.426 246.426 ↑ 1.0 1 82,142 / 3

Index Only Scan using pond_curator_verify_x1 on pond_curator_verify pvc (cost=0.57..1.51 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=82,142)

  • Index Cond: (pond_item_common = pic.objectid)
  • Heap Fetches: 3244
9. 2.783 2.783 ↑ 11.0 1 23 / 3

Index Scan using pond_pricing_x1 on pond_pricing pp (cost=0.57..7.86 rows=11 width=4) (actual time=0.183..0.363 rows=1 loops=23)

  • Index Cond: (pond_item_common = pic.objectid)
  • Filter: ((date_trunc('day'::text, (CURRENT_TIMESTAMP + '14 days'::interval)) >= startdate) AND (date_trunc('day'::text,(CURRENT_TIMESTAMP + '14 days'::interval)) <= stopdate))
  • Rows Removed by Filter: 2
Planning time : 1.153 ms
Execution time : 3,928.648 ms