explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2gPc

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 1,636.941 ↑ 1.0 100 1

Limit (cost=42,604.63..42,616.30 rows=100 width=810) (actual time=1,636.531..1,636.941 rows=100 loops=1)

2. 1.164 1,636.929 ↑ 4.8 100 1

Gather Merge (cost=42,604.63..42,661.10 rows=484 width=810) (actual time=1,636.529..1,636.929 rows=100 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
3. 15.215 1,635.765 ↑ 2.4 100 1

Sort (cost=41,604.61..41,605.21 rows=242 width=810) (actual time=1,635.750..1,635.765 rows=100 loops=1)

  • Sort Key: message0_.create_time DESC
  • Sort Method: quicksort Memory: 7935kB
4. 17.329 1,620.550 ↓ 60.2 14,569 1

Nested Loop (cost=528.41..41,595.02 rows=242 width=810) (actual time=555.645..1,620.550 rows=14,569 loops=1)

5. 920.085 1,472.100 ↓ 2.4 14,569 1

Parallel Bitmap Heap Scan on messages_folders messagefol1_ (cost=527.98..7,976.67 rows=5,998 width=4) (actual time=555.581..1,472.100 rows=14,569 loops=1)

  • Recheck Cond: (id_folder = 548)
  • Heap Blocks: exact=371
6. 552.015 552.015 ↓ 1.0 14,569 1

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

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

Index Scan using messages_id_pec_id_idx on messages message0_ (cost=0.43..5.60 rows=1 width=810) (actual time=0.009..0.009 rows=1 loops=14,569)

  • Index Cond: ((id_pec = 488) AND (id = messagefol1_.id_message))
Planning time : 0.553 ms
Execution time : 1,637.045 ms