explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n0f

Settings
# exclusive inclusive rows x rows loops node
1. 1,548.774 3,023,050.356 ↑ 1.0 1 1

Aggregate (cost=12,181,069.82..12,181,069.83 rows=1 width=0) (actual time=3,023,050.355..3,023,050.356 rows=1 loops=1)

  • Buffers: shared hit=64995 read=5165240 dirtied=92979
2. 2,852.943 3,021,501.582 ↓ 1.1 3,562,016 1

Nested Loop (cost=168,841.33..12,172,832.20 rows=3,295,045 width=0) (actual time=3,558.295..3,021,501.582 rows=3,562,016 loops=1)

  • Buffers: shared hit=64995 read=5165240 dirtied=92979
3. 0.002 0.032 ↑ 1.0 1 1

Nested Loop (cost=0.70..16.75 rows=1 width=4) (actual time=0.025..0.032 rows=1 loops=1)

  • Buffers: shared hit=7
4. 0.015 0.015 ↑ 1.0 1 1

Index Only Scan using auth_user_pkey on auth_user (cost=0.29..8.30 rows=1 width=4) (actual time=0.013..0.015 rows=1 loops=1)

  • Index Cond: (id = 8746)
  • Heap Fetches: 0
  • Buffers: shared hit=3
5. 0.015 0.015 ↑ 1.0 1 1

Index Scan using tsdb_tsportal_profile_user_id_key on tsdb_tsportal_profile (cost=0.41..8.43 rows=1 width=4) (actual time=0.010..0.015 rows=1 loops=1)

  • Index Cond: (user_id = 8746)
  • Filter: (user_organization_id = 1830)
  • Buffers: shared hit=4
6. 3,015,548.226 3,018,648.607 ↓ 1.1 3,562,016 1

Bitmap Heap Scan on tsdb_tsapiuseraction (cost=168,840.63..12,139,865.00 rows=3,295,045 width=4) (actual time=3,558.265..3,018,648.607 rows=3,562,016 loops=1)

  • Recheck Cond: (user_id = 8746)
  • Rows Removed by Index Recheck: 228188737
  • Filter: (created_ts >= '2019-10-10 04:00:00+00'::timestamp with time zone)
  • Rows Removed by Filter: 4682813
  • Heap Blocks: exact=1157693 lossy=4043988
  • Buffers: shared hit=64988 read=5165240 dirtied=92979
7. 3,100.381 3,100.381 ↓ 1.1 8,244,829 1

Bitmap Index Scan on tsdb_tsapiuseraction_user_id (cost=0.00..168,016.87 rows=7,823,506 width=0) (actual time=3,100.381..3,100.381 rows=8,244,829 loops=1)

  • Index Cond: (user_id = 8746)
  • Buffers: shared hit=28547
Planning time : 1.109 ms
Execution time : 3,023,058.187 ms