explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JBMn

Settings
# exclusive inclusive rows x rows loops node
1. 795.752 32,226.417 ↑ 1.0 1 1

Aggregate (cost=12,181,069.82..12,181,069.83 rows=1 width=0) (actual time=32,226.416..32,226.417 rows=1 loops=1)

  • Buffers: shared hit=5230235
2. 1,524.639 31,430.665 ↓ 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,599.143..31,430.665 rows=3,562,016 loops=1)

  • Buffers: shared hit=5230235
3. 0.004 0.035 ↑ 1.0 1 1

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

  • Buffers: shared hit=7
4. 0.016 0.016 ↑ 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.014..0.016 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. 26,767.221 29,905.991 ↓ 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,599.112..29,905.991 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=5230228
7. 3,138.770 3,138.770 ↓ 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,138.770..3,138.770 rows=8,244,829 loops=1)

  • Index Cond: (user_id = 8746)
  • Buffers: shared hit=28547
Planning time : 1.087 ms
Execution time : 32,234.818 ms