explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iYdd

Settings
# exclusive inclusive rows x rows loops node
1. 0.045 842.324 ↑ 1.0 100 1

Limit (cost=115,900.79..115,912.45 rows=100 width=810) (actual time=817.370..842.324 rows=100 loops=1)

2. 0.000 842.279 ↑ 28.5 200 1

Gather Merge (cost=115,889.12..116,554.86 rows=5,706 width=810) (actual time=817.249..842.279 rows=200 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 198.060 2,341.299 ↑ 28.2 101 3

Sort (cost=114,889.09..114,896.23 rows=2,853 width=810) (actual time=780.402..780.433 rows=101 loops=3)

  • Sort Key: message0_.create_time DESC
  • Sort Method: quicksort Memory: 14928kB
4. 145.628 2,143.239 ↓ 7.7 21,847 3

Nested Loop (cost=2,385.31..114,725.36 rows=2,853 width=810) (actual time=342.070..714.413 rows=21,847 loops=3)

5. 923.080 1,276.671 ↑ 1.2 21,847 3

Parallel Bitmap Heap Scan on messages_folders messagefol1_ (cost=2,384.88..10,062.90 rows=27,121 width=4) (actual time=341.940..425.557 rows=21,847 loops=3)

  • Recheck Cond: (id_folder = 697)
  • Heap Blocks: exact=494
6. 353.591 353.591 ↓ 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=353.591..353.591 rows=65,540 loops=1)

  • Index Cond: (id_folder = 697)
7. 720.940 720.940 ↑ 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.011..0.011 rows=1 loops=65,540)

  • Index Cond: ((id_pec = 524) AND (id = messagefol1_.id_message))
Planning time : 0.701 ms
Execution time : 845.544 ms