explain.depesz.com

PostgreSQL's explain analyze made readable

Result: emta

Settings
# exclusive inclusive rows x rows loops node
1. 3,437.318 14,754.139 ↑ 135.8 19,928 1

Merge Semi Join (cost=30,201.11..751,026.59 rows=2,706,124 width=942) (actual time=2,855.965..14,754.139 rows=19,928 loops=1)

  • Merge Cond: (system_looks.id = ((moderator_stats.target)::integer))
2. 8,950.648 8,950.648 ↑ 1.0 5,206,693 1

Index Scan using pk_system_looks on system_looks (cost=0.43..680,034.83 rows=5,412,247 width=942) (actual time=477.451..8,950.648 rows=5,206,693 loops=1)

  • Filter: ((task_id)::text ~~ '%lamoda%'::text)
  • Rows Removed by Filter: 561183
3. 36.720 2,366.173 ↓ 1.9 20,111 1

Sort (cost=30,200.68..30,226.74 rows=10,424 width=7) (actual time=2,350.230..2,366.173 rows=20,111 loops=1)

  • Sort Key: ((moderator_stats.target)::integer)
  • Sort Method: quicksort Memory: 1711kB
4. 1,793.549 2,329.453 ↓ 1.9 20,111 1

Bitmap Heap Scan on moderator_stats (cost=306.03..29,505.00 rows=10,424 width=7) (actual time=544.405..2,329.453 rows=20,111 loops=1)

  • Recheck Cond: (user_id = 11112)
  • Filter: ((type)::text = 'Accept_Look'::text)
  • Rows Removed by Filter: 3867
  • Heap Blocks: exact=1499
5. 535.904 535.904 ↓ 1.8 23,978 1

Bitmap Index Scan on ix_moderator_stats_user_id (cost=0.00..303.43 rows=13,199 width=0) (actual time=535.904..535.904 rows=23,978 loops=1)

  • Index Cond: (user_id = 11112)
Planning time : 46.896 ms
Execution time : 14,767.140 ms