explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tA5k

Settings
# exclusive inclusive rows x rows loops node
1. 33.392 1,624.812 ↓ 0.0 0 1

Hash Join (cost=1,060.83..97,723.08 rows=55 width=56) (actual time=1,624.802..1,624.812 rows=0 loops=1)

  • Hash Cond: (dc.default_type = uv.default_type)
  • Join Filter: ((NOT (SubPlan 2)) OR (dc.status <> (SubPlan 3)))
  • Rows Removed by Join Filter: 196
2.          

CTE user_views

3. 2.302 2.302 ↑ 1.2 11 1

Seq Scan on client_view c (cost=0.00..1,060.40 rows=13 width=12) (actual time=0.259..2.302 rows=11 loops=1)

  • Filter: ((user_id = '1693876180748338218'::bigint) AND (status = 7401))
  • Rows Removed by Filter: 2416
4. 4.419 4.419 ↑ 1.8 463 1

Seq Scan on default_cols dc (cost=0.00..18.50 rows=850 width=52) (actual time=0.042..4.419 rows=463 loops=1)

5. 0.148 2.733 ↑ 1.2 11 1

Hash (cost=0.26..0.26 rows=13 width=12) (actual time=2.723..2.733 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 2.585 2.585 ↑ 1.2 11 1

CTE Scan on user_views uv (cost=0.00..0.26 rows=13 width=12) (actual time=0.299..2.585 rows=11 loops=1)

7.          

SubPlan (forHash Join)

8. 799.092 799.092 ↑ 1.8 12 196

Seq Scan on viewable_column vc (cost=0.00..1,087.80 rows=21 width=11) (actual time=3.941..4.077 rows=12 loops=196)

  • Filter: (client_view_id = uv.id)
  • Rows Removed by Filter: 36341
9. 8.036 785.176 ↑ 1.0 1 196

Limit (cost=0.00..1,213.16 rows=1 width=4) (actual time=3.981..4.006 rows=1 loops=196)

10. 777.140 777.140 ↑ 1.0 1 196

Seq Scan on viewable_column vc_1 (cost=0.00..1,213.16 rows=1 width=4) (actual time=3.957..3.965 rows=1 loops=196)

  • Filter: ((client_view_id = uv.id) AND (dc.display_name = display_name))
  • Rows Removed by Filter: 36353