explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gbqr : p1

Settings
# exclusive inclusive rows x rows loops node
1. 0.100 4.887 ↑ 1.0 1 1

Aggregate (cost=144.56..144.57 rows=1 width=16) (actual time=4.887..4.887 rows=1 loops=1)

2. 0.180 4.787 ↓ 21.5 172 1

Hash Semi Join (cost=24.54..144.50 rows=8 width=16) (actual time=2.685..4.787 rows=172 loops=1)

  • Hash Cond: (article_links.source_id = sources.id)
3. 3.764 3.764 ↓ 2.3 676 1

Index Scan using index_article_links_on_created_at on article_links (cost=0.43..119.54 rows=291 width=20) (actual time=1.654..3.764 rows=676 loops=1)

  • Index Cond: (created_at >= '2018-12-04 05:25:44.678372'::timestamp without time zone)
  • Filter: ((state)::text = 'success'::text)
  • Rows Removed by Filter: 38
4. 0.017 0.843 ↓ 12.0 60 1

Hash (cost=24.05..24.05 rows=5 width=4) (actual time=0.843..0.843 rows=60 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
5. 0.695 0.826 ↓ 12.0 60 1

Bitmap Heap Scan on sources (cost=4.46..24.05 rows=5 width=4) (actual time=0.220..0.826 rows=60 loops=1)

  • Recheck Cond: (((type)::text = 'OnlineSource'::text) AND (priority <= 4))
6. 0.131 0.131 ↓ 56.6 283 1

Bitmap Index Scan on index_sources_on_type_and_priority (cost=0.00..4.46 rows=5 width=0) (actual time=0.131..0.131 rows=283 loops=1)

  • Index Cond: (((type)::text = 'OnlineSource'::text) AND (priority <= 4))