explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cS9N

Settings
# exclusive inclusive rows x rows loops node
1. 0.043 1,412.135 ↑ 1.0 100 1

Limit (cost=115,882.45..115,894.12 rows=100 width=810) (actual time=1,411.048..1,412.135 rows=100 loops=1)

2. 2.430 1,412.092 ↑ 57.1 100 1

Gather Merge (cost=115,882.45..116,548.20 rows=5,706 width=810) (actual time=1,411.042..1,412.092 rows=100 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
3. 184.721 1,409.662 ↑ 28.5 100 1

Sort (cost=114,882.43..114,889.56 rows=2,853 width=810) (actual time=1,409.635..1,409.662 rows=100 loops=1)

  • Sort Key: message0_.create_time DESC
  • Sort Method: quicksort Memory: 37595kB
4. 142.577 1,224.941 ↓ 23.0 65,540 1

Nested Loop (cost=2,385.31..114,718.69 rows=2,853 width=810) (actual time=532.263..1,224.941 rows=65,540 loops=1)

5. 96.006 623.584 ↓ 2.4 65,540 1

Parallel Bitmap Heap Scan on messages_folders messagefol1_ (cost=2,384.88..10,062.90 rows=27,121 width=4) (actual time=528.025..623.584 rows=65,540 loops=1)

  • Recheck Cond: (id_folder = 697)
  • Heap Blocks: exact=1087
6. 527.578 527.578 ↓ 1.0 65,540 1

Bitmap Index Scan on messages_folders_id_folder_idx (cost=0.00..2,368.61 rows=65,091 width=0) (actual time=527.578..527.578 rows=65,540 loops=1)

  • Index Cond: (id_folder = 697)
7. 458.780 458.780 ↑ 1.0 1 65,540

Index Scan using messages_id_pec_id_idx on messages message0_ (cost=0.43..3.86 rows=1 width=810) (actual time=0.007..0.007 rows=1 loops=65,540)

  • Index Cond: ((id_pec = 524) AND (id = messagefol1_.id_message))
Planning time : 1.296 ms
Execution time : 1,424.323 ms