explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TZmM

Settings
# exclusive inclusive rows x rows loops node
1. 0.067 371.289 ↑ 1.0 100 1

Limit (cost=48,545.12..48,556.79 rows=100 width=810) (actual time=359.175..371.289 rows=100 loops=1)

2. 0.000 371.222 ↑ 4.8 100 1

Gather Merge (cost=48,545.12..48,601.60 rows=484 width=810) (actual time=359.173..371.222 rows=100 loops=1)

  • Workers Planned: 2
  • Workers Launched: 1
3. 20.360 698.312 ↑ 1.7 140 2

Sort (cost=47,545.10..47,545.71 rows=242 width=810) (actual time=349.114..349.156 rows=140 loops=2)

  • Sort Key: message0_.create_time DESC
  • Sort Method: quicksort Memory: 4313kB
4. 22.216 677.952 ↓ 29.8 7,203 2

Nested Loop (cost=528.41..47,535.52 rows=242 width=810) (actual time=74.983..338.976 rows=7,203 loops=2)

5. 199.674 281.180 ↓ 1.2 7,203 2

Parallel Bitmap Heap Scan on messages_folders messagefol1_ (cost=527.98..7,976.67 rows=5,998 width=4) (actual time=74.878..140.590 rows=7,203 loops=2)

  • Recheck Cond: (id_folder = 548)
  • Heap Blocks: exact=206
6. 81.506 81.506 ↓ 1.0 14,406 1

Bitmap Index Scan on messages_folders_id_folder_idx (cost=0.00..524.38 rows=14,394 width=0) (actual time=81.506..81.506 rows=14,406 loops=1)

  • Index Cond: (id_folder = 548)
7. 374.556 374.556 ↑ 1.0 1 14,406

Index Scan using messages_pkey on messages message0_ (cost=0.43..6.60 rows=1 width=810) (actual time=0.026..0.026 rows=1 loops=14,406)

  • Index Cond: (id = messagefol1_.id_message)
  • Filter: (id_pec = 488)
Planning time : 0.444 ms
Execution time : 371.542 ms