explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xM7x

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 292.278 ↑ 1.0 100 1

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

2. 0.000 292.263 ↑ 4.8 100 1

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

  • Workers Planned: 2
  • Workers Launched: 2
3. 28.566 825.417 ↑ 1.7 141 3

Sort (cost=41,604.61..41,605.21 rows=242 width=810) (actual time=275.116..275.139 rows=141 loops=3)

  • Sort Key: message0_.create_time DESC
  • Sort Method: quicksort Memory: 3525kB
4. 30.562 796.851 ↓ 20.1 4,856 3

Nested Loop (cost=528.41..41,595.02 rows=242 width=810) (actual time=103.290..265.617 rows=4,856 loops=3)

5. 497.881 606.030 ↑ 1.2 4,856 3

Parallel Bitmap Heap Scan on messages_folders messagefol1_ (cost=527.98..7,976.67 rows=5,998 width=4) (actual time=103.182..202.010 rows=4,856 loops=3)

  • Recheck Cond: (id_folder = 548)
  • Heap Blocks: exact=176
6. 108.149 108.149 ↓ 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=108.148..108.149 rows=14,569 loops=1)

  • Index Cond: (id_folder = 548)
7. 160.259 160.259 ↑ 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.011..0.011 rows=1 loops=14,569)

  • Index Cond: ((id_pec = 488) AND (id = messagefol1_.id_message))
Planning time : 0.737 ms
Execution time : 292.437 ms