explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yJYE

Settings
# exclusive inclusive rows x rows loops node
1. 0.144 41.808 ↑ 1.0 1 1

Aggregate (cost=134.61..134.62 rows=1 width=8) (actual time=41.807..41.808 rows=1 loops=1)

  • Buffers: shared hit=25 read=37 dirtied=2
  • I/O Timings: read=41.234
2. 0.003 41.664 ↓ 0.0 0 1

Nested Loop (cost=0.72..134.60 rows=5 width=4) (actual time=41.663..41.664 rows=0 loops=1)

  • Buffers: shared hit=25 read=37 dirtied=2
  • I/O Timings: read=41.234
3. 41.661 41.661 ↓ 0.0 0 1

Index Scan using index_users_ops_dashboard_projects_on_user_id_and_project_id on public.users_ops_dashboard_projects (cost=0.29..112.27 rows=5 width=4) (actual time=41.661..41.661 rows=0 loops=1)

  • Index Cond: ((users_ops_dashboard_projects.user_id >= 0) AND (users_ops_dashboard_projects.user_id <= 9999))
  • Filter: ((users_ops_dashboard_projects.created_at >= '2020-02-20 16:31:06.587165+00'::timestamp with time zone) AND (users_ops_dashboard_projects.created_at <= '2020-03-19 16:31:06.587255+00'::timestamp with time zone))
  • Rows Removed by Filter: 80
  • Buffers: shared hit=25 read=37 dirtied=2
  • I/O Timings: read=41.234
4. 0.000 0.000 ↓ 0.0 0 0

Index Scan using users_pkey on public.users (cost=0.43..4.46 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=0)

  • Index Cond: (users.id = users_ops_dashboard_projects.user_id)
  • Filter: ((users.ghost IS NOT TRUE) AND ((users.state)::text = 'active'::text) AND ((users.user_type IS NULL) OR (users.user_type <> ALL ('{2,1,3}'::integer[]))))
  • Rows Removed by Filter: 0