explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9vyc

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 128.206 ↑ 1.0 1 1

Aggregate (cost=9,121.07..9,121.08 rows=1 width=8) (actual time=128.205..128.206 rows=1 loops=1)

  • time=0.136..0.140 rows=1 loops=1)
  • loops=3)
2. 0.147 128.199 ↓ 0.0 0 1

Nested Loop (cost=1,037.82..9,119.14 rows=770 width=0) (actual time=128.199..128.199 rows=0 loops=1)

  • -> Index Only Scan using pond_user_pkey on pond_user pu (cost=0.43..2.44 rows=1 width=4) (actual
  • Index Cond: (objectid = 1439269)
  • Heap Fetches: 1
3. 4.852 128.052 ↓ 0.0 0 1

Gather (cost=1,037.40..9,109.00 rows=770 width=4) (actual time=128.052..128.052 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • -> Nested Loop (cost=37.40..8032.00 rows=321 width=4) (actual time=123.202..123.202 rows=0
4. 57.080 123.200 ↓ 0.0 0 3 / 3

Nested Loop Anti Join (cost=36.83..5,214.70 rows=325 width=8) (actual time=123.200..123.200 rows=0 loops=3)

5. 66.120 66.120 ↑ 1.6 456 3 / 3

Parallel Bitmap Heap Scan on pond_item_common pic (cost=36.26..4,099.22 rows=737 width=10) (actual time=1.447..66.120 rows=456 loops=3)

  • Recheck Cond: (pond_user = 1439269)
  • Filter: ((video_standard < 800) AND (video_standard < 800) AND (status = 30) AND (status = ANY ('{7,8,9,10,30}'::integer[])))
  • Rows Removed by Filter: 28
  • Heap Blocks: exact=554
  • -> Bitmap Index Scan on pond_item_common_x1r (cost=0.00..35.82 rows=4019
6. 0.000 3.603 ↓ 0.0 2,219 1

width=0) (cost=0..0 rows=0 width=0) (actual time=3.603..3.603 rows=2,219 loops=1)

  • Index Cond: (pond_user = 1439269)
7. 162.673 162.673 ↑ 1.0 1 1,367

Index Only Scan using pond_curator_verify_x1 on pond_curator_verify pvc (cost=0.57..1.59 rows=1 width=4) (actual time=0.119..0.119 rows=1 loops=1,367)

  • Index Cond: (pond_item_common = pic.objectid)
  • Heap Fetches: 54
8. 0.000 0.000 ↓ 0.0 0

Index Scan using pond_pricing_x1 on pond_pricing pp (cost=0.57..8.56 rows=11 width=4) (never executed)

  • 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))
Planning time : 7.767 ms
Execution time : 138.063 ms