explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2dgT

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 3.104 ↓ 10.0 10 1

Limit (cost=471.58..471.58 rows=1 width=393) (actual time=3.100..3.104 rows=10 loops=1)

2. 0.016 3.100 ↓ 10.0 10 1

Sort (cost=471.58..471.58 rows=1 width=393) (actual time=3.099..3.100 rows=10 loops=1)

  • Sort Key: a.job_post_date DESC
  • Sort Method: top-N heapsort Memory: 29kB
3. 0.030 3.084 ↓ 31.0 31 1

WindowAgg (cost=451.42..471.57 rows=1 width=393) (actual time=3.073..3.084 rows=31 loops=1)

4. 2.923 3.054 ↓ 31.0 31 1

Nested Loop (cost=451.42..471.56 rows=1 width=385) (actual time=0.444..3.054 rows=31 loops=1)

5. 0.024 0.131 ↓ 34.0 34 1

HashAggregate (cost=451.00..451.01 rows=1 width=26) (actual time=0.122..0.131 rows=34 loops=1)

  • Group Key: (a_1.account_location)::text
6. 0.011 0.107 ↓ 34.0 34 1

Nested Loop (cost=0.70..451.00 rows=1 width=26) (actual time=0.018..0.107 rows=34 loops=1)

7. 0.024 0.024 ↑ 1.0 36 1

Index Scan using account_sites_account_id_account_location_site_class_key3 on account_sites a_1 (cost=0.41..147.00 rows=37 width=34) (actual time=0.011..0.024 rows=36 loops=1)

  • Index Cond: ((account_id = 75,130) AND (site_class = 'R&D'::draup.site_class))
8. 0.072 0.072 ↑ 1.0 1 36

Index Scan using account_sites_with_subvertical__account_site_id_account_id_key2 on account_sites_with_subvertical_details asd (cost=0.29..8.20 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=36)

  • Index Cond: ((account_site_id = a_1.account_site_id) AND (account_id = 75,130))
  • Filter: (subverticals && '{"Artificial Intelligence & Data Science"}'::character varying[])
  • Rows Removed by Filter: 0