explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JG5b

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.032 ↓ 0.0 0 1

Limit (cost=22,197.89..22,197.97 rows=32 width=810) (actual time=0.032..0.032 rows=0 loops=1)

2. 0.017 0.031 ↓ 0.0 0 1

Sort (cost=22,197.89..22,197.97 rows=32 width=810) (actual time=0.031..0.031 rows=0 loops=1)

  • Sort Key: message0_.create_time DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.014 ↓ 0.0 0 1

Hash Join (cost=8,341.69..22,197.09 rows=32 width=810) (actual time=0.014..0.014 rows=0 loops=1)

  • Hash Cond: (message0_.id = messagefol1_.id_message)
4. 0.001 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on messages message0_ (cost=80.13..13,924.79 rows=4,091 width=810) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: (id_pec = 697)
5. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on messages_id_pec_id_idx (cost=0.00..79.11 rows=4,091 width=0) (actual time=0.012..0.013 rows=0 loops=1)

  • Index Cond: (id_pec = 697)
6. 0.000 0.000 ↓ 0.0 0

Hash (cost=8,081.63..8,081.63 rows=14,394 width=4) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on messages_folders messagefol1_ (cost=527.98..8,081.63 rows=14,394 width=4) (never executed)

  • Recheck Cond: (id_folder = 548)
8. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on messages_folders_id_folder_idx (cost=0.00..524.38 rows=14,394 width=0) (never executed)

  • Index Cond: (id_folder = 548)
Planning time : 0.521 ms
Execution time : 0.120 ms