explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 11R6

Settings
# exclusive inclusive rows x rows loops node
1. 3.800 4,572.623 ↓ 1.1 975 1

Nested Loop Left Join (cost=29.12..11,286.27 rows=928 width=20) (actual time=7.248..4,572.623 rows=975 loops=1)

2. 3.181 1,772.523 ↓ 1.1 975 1

Nested Loop (cost=28.55..6,975.66 rows=928 width=8) (actual time=5.676..1,772.523 rows=975 loops=1)

3. 3.678 8.492 ↓ 1.1 975 1

Bitmap Heap Scan on organisation_vendor_watchlist owl (cost=28.12..420.78 rows=928 width=8) (actual time=4.835..8.492 rows=975 loops=1)

  • Recheck Cond: (organisation_id = 1586)
  • Filter: watched
  • Heap Blocks: exact=84
4. 4.814 4.814 ↑ 1.0 975 1

Bitmap Index Scan on organisation_vendor_watchlist_org_id_idx (cost=0.00..27.89 rows=1,013 width=0) (actual time=4.814..4.814 rows=975 loops=1)

  • Index Cond: (organisation_id = 1586)
5. 1,760.850 1,760.850 ↑ 1.0 1 975

Index Only Scan using vendors_datastore_vendor_id_idx on vendors v (cost=0.43..7.05 rows=1 width=8) (actual time=1.784..1.806 rows=1 loops=975)

  • Index Cond: (datastore_vendor_id = owl.datastore_vendor_id)
  • Heap Fetches: 975
6. 2.925 2,796.300 ↑ 1.0 1 975

Limit (cost=0.57..4.63 rows=1 width=12) (actual time=2.868..2.868 rows=1 loops=975)

7. 2,793.375 2,793.375 ↑ 699.0 1 975

Index Scan using vendor_scores_vendor_scored_at on vendor_scores (cost=0.57..2,836.80 rows=699 width=12) (actual time=2.865..2.865 rows=1 loops=975)

  • Index Cond: (datastore_vendor_id = owl.datastore_vendor_id)
Planning time : 0.445 ms
Execution time : 4,572.955 ms