explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9dVc

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 246.272 ↑ 1.0 18 1

Limit (cost=36,687.56..37,304.10 rows=18 width=944) (actual time=244.693..246.272 rows=18 loops=1)

2. 0.508 246.270 ↑ 914.1 18 1

Merge Semi Join (cost=36,687.56..600,241.32 rows=16,453 width=944) (actual time=244.692..246.270 rows=18 loops=1)

  • Merge Cond: (system_looks.id = ((moderator_stats.target)::integer))
3. 235.877 235.877 ↑ 482.4 11,137 1

Index Scan using pk_system_looks on system_looks (cost=0.43..522,913.21 rows=5,372,655 width=944) (actual time=229.003..235.877 rows=11,137 loops=1)

  • Filter: ((task_id)::text ~~ '%lamoda%'::text)
  • Rows Removed by Filter: 499487
4. 4.513 9.885 ↑ 1,008.6 18 1

Sort (cost=36,687.13..36,732.51 rows=18,154 width=7) (actual time=9.883..9.885 rows=18 loops=1)

  • Sort Key: ((moderator_stats.target)::integer)
  • Sort Method: quicksort Memory: 1700kB
5. 4.163 5.372 ↓ 1.1 19,878 1

Bitmap Heap Scan on moderator_stats (cost=482.51..35,402.92 rows=18,154 width=7) (actual time=1.326..5.372 rows=19,878 loops=1)

  • Recheck Cond: ((user_id = 11112) AND ((type)::text = 'Accept_Look'::text))
  • Heap Blocks: exact=1150
6. 1.209 1.209 ↓ 1.1 19,878 1

Bitmap Index Scan on user_id_type_idx (cost=0.00..477.97 rows=18,154 width=0) (actual time=1.209..1.209 rows=19,878 loops=1)

  • Index Cond: ((user_id = 11112) AND ((type)::text = 'Accept_Look'::text))
Planning time : 0.230 ms
Execution time : 246.324 ms