explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xiYy

Settings
# exclusive inclusive rows x rows loops node
1. 784.480 4,603.354 ↑ 1.0 1 1

Aggregate (cost=12,195,010.99..12,195,011.00 rows=1 width=0) (actual time=4,603.353..4,603.354 rows=1 loops=1)

  • Buffers: shared hit=197,664
2. 1,472.455 3,818.874 ↓ 1.1 3,562,016 1

Nested Loop (cost=145,980.64..12,186,735.26 rows=3,310,291 width=0) (actual time=556.571..3,818.874 rows=3,562,016 loops=1)

  • Buffers: shared hit=197,664
3. 0.003 0.030 ↑ 1.0 1 1

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

  • Buffers: shared hit=7
4. 0.013 0.013 ↑ 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.011..0.013 rows=1 loops=1)

  • Index Cond: (id = 8,746)
  • Heap Fetches: 0
  • Buffers: shared hit=3
5. 0.014 0.014 ↑ 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.011..0.014 rows=1 loops=1)

  • Index Cond: (user_id = 8,746)
  • Filter: (user_organization_id = 1,830)
  • Buffers: shared hit=4
6. 1,828.669 2,346.389 ↓ 1.1 3,562,016 1

Bitmap Heap Scan on tsdb_tsapiuseraction (cost=145,979.94..12,153,615.60 rows=3,310,291 width=4) (actual time=556.545..2,346.389 rows=3,562,016 loops=1)

  • Recheck Cond: (user_id = 8,746)
  • Filter: (created_ts >= '2019-10-10 04:00:00+00'::timestamp with time zone)
  • Rows Removed by Filter: 4,682,813
  • Heap Blocks: exact=175,126
  • Buffers: shared hit=197,657
7. 517.720 517.720 ↓ 1.0 8,244,829 1

Bitmap Index Scan on tsdb_tsapiuseraction_user_id (cost=0.00..145,152.36 rows=7,859,705 width=0) (actual time=517.720..517.720 rows=8,244,829 loops=1)

  • Index Cond: (user_id = 8,746)
  • Buffers: shared hit=22,531
Planning time : 0.200 ms
Execution time : 4,603.445 ms