explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 71E

options
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0
→

Limit (cost=293874.88..293874.89 rows=2 width=24) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0
→

Sort (cost=293874.88..293882.85 rows=3188 width=24) (actual time=.. rows= loops=)

  • Sort Key: ps.score
3. 0.000 0.000 ↓ 0.0
→

HashAggregate (cost=293811.12..293843.00 rows=3188 width=24) (actual time=.. rows= loops=)

4. 0.000 0.000 ↓ 0.0
→

Hash Join (cost=5973.94..293795.18 rows=3188 width=24) (actual time=.. rows= loops=)

  • Hash Cond: (mp.poi_id = ps.poi_id)
5. 0.000 0.000 ↓ 0.0
→

Hash Join (cost=3342.23..289087.68 rows=233591 width=16) (actual time=.. rows= loops=)

  • Hash Cond: (mp.category_id = etc.category_id)
6. 0.000 0.000 ↓ 0.0
→

Seq Scan on poi mp (cost=3339.33..271614.48 rows=3026877 width=20) (actual time=.. rows= loops=)

  • Filter: (((area_id = 179917) OR (hashed SubPlan 1)) AND (poi_id <> ALL ('{0d3cbbd0-7f7b-4d61-933d-d8180dda8e7f,a70c7f7d-d35e-4bec-a633-38cd2ad11c75,dca7c0b1-cb28-4bae-8a35-ddb4e532e696,f16751b8-7e7c-11e1-9b2d-12313f066d67,21dfcdb6-f59b-4ac0-8aad-96071bf4912e,723a0bf9-c410-4816-91c7-eaf7b2c9bb35,d3e5fb68-9636-11e1-8780-12313f066d67,4be76dbe-7499-459a-b6bd-4241ceb3573c}'::uuid[])))
7.          

SubPlan (forSeq Scan)
8. 0.000 0.000 ↓ 0.0
→

Hash Join (cost=223.30..3339.33 rows=1 width=4) (actual time=.. rows= loops=)

  • Hash Cond: (ms.sub_area_id = ma.area_id)
9. 0.000 0.000 ↓ 0.0
→

Seq Scan on sub_areas_information ms (cost=0.00..3115.68 rows=92 width=4) (actual time=.. rows= loops=)

  • Filter: (area_id = 179917)
10. 0.000 0.000 ↓ 0.0
→

Hash (cost=211.25..211.25 rows=964 width=4) (actual time=.. rows= loops=)

11. 0.000 0.000 ↓ 0.0
→

Index Scan using idx_maponics_area_is_supported on area ma (cost=0.00..211.25 rows=964 width=4) (actual time=.. rows= loops=)

  • Index Cond: (is_supported = true)
  • Filter: (is_supported IS TRUE)
12. 0.000 0.000 ↓ 0.0
→

Hash (cost=2.66..2.66 rows=19 width=2) (actual time=.. rows= loops=)

13. 0.000 0.000 ↓ 0.0
→

Seq Scan on event_type_category etc (cost=0.00..2.66 rows=19 width=2) (actual time=.. rows= loops=)

  • Filter: (event_type_id = 24)
14. 0.000 0.000 ↓ 0.0
→

Hash (cost=1599.09..1599.09 rows=82609 width=24) (actual time=.. rows= loops=)

15. 0.000 0.000 ↓ 0.0
→

Seq Scan on poi_score ps (cost=0.00..1599.09 rows=82609 width=24) (actual time=.. rows= loops=)