explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ps94

Settings
# exclusive inclusive rows x rows loops node
1. 0.291 375.294 ↑ 1.0 1 1

Aggregate (cost=391.94..391.95 rows=1 width=8) (actual time=375.294..375.294 rows=1 loops=1)

2. 29.651 375.003 ↓ 3,281.0 3,281 1

Nested Loop (cost=1.31..391.94 rows=1 width=0) (actual time=0.528..375.003 rows=3,281 loops=1)

3. 96.544 96.672 ↓ 4,144.7 49,736 1

Nested Loop (cost=0.87..384.60 rows=12 width=4) (actual time=0.049..96.672 rows=49,736 loops=1)

  • -> Index Scan using index_label_links_on_label_id on label_links (cost=0.44..61.18 rows=72 width=8) (actual time=0.022..15.170 row
4. 0.128 0.128 ↑ 1.0 6 1

Index Only Scan using labels_pkey on labels (cost=0.43..13.21 rows=6 width=4) (actual time=0.011..0.128 rows=6 loops=1)

  • Index Cond: (id = ANY ('{2731248,10230929,4116705,2492649,2278648,2779806}'::integer[]))
  • Heap Fetches: 1
  • Index Cond: (label_id = labels.id)
  • Filter: ((target_type)::text = 'Issue'::text)
  • Rows Removed by Filter: 3130
5. 248.680 248.680 ↓ 0.0 0 49,736

Index Scan using issues_pkey on issues (cost=0.44..0.60 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=49,736)

  • Index Cond: (id = label_links.target_id)
  • Filter: ((created_at <= '2019-08-01 00:00:00+00'::timestamp with time zone) AND (created_at >= '2019-05-01 00:00:00+00'::timestamp w
  • Rows Removed by Filter: 1
Planning time : 0.808 ms
Execution time : 375.436 ms