explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jsdu

Settings
# exclusive inclusive rows x rows loops node
1. 16.745 529.925 ↑ 1.1 22 1

Sort (cost=247.96..248.02 rows=24 width=148) (actual time=529.920..529.925 rows=22 loops=1)

  • Sort Key: odiceedocu1_.date_creation
  • Sort Method: quicksort Memory: 69940kB
  • Buffers: shared hit=9223
2. 512.825 513.180 ↑ 1.1 22 1

Nested Loop (cost=4.76..247.41 rows=24 width=148) (actual time=5.939..513.180 rows=22 loops=1)

  • Buffers: shared hit=9223
3. 0.056 0.069 ↑ 1.1 22 1

Bitmap Heap Scan on dossier_document documents0_ (cost=4.47..64.03 rows=24 width=16) (actual time=0.019..0.069 rows=22 loops=1)

  • Recheck Cond: (dossier_id = '39678'::bigint)
  • Heap Blocks: exact=3
  • Buffers: shared hit=5
4. 0.013 0.013 ↑ 1.1 22 1

Bitmap Index Scan on uk_dossier_document_id (cost=0.00..4.47 rows=24 width=0) (actual time=0.013..0.013 rows=22 loops=1)

  • Index Cond: (dossier_id = '39678'::bigint)
  • Buffers: shared hit=2
5. 0.286 0.286 ↑ 1.0 1 22

Index Scan using document_pkey on document odiceedocu1_ (cost=0.29..7.64 rows=1 width=124) (actual time=0.013..0.013 rows=1 loops=22)

  • Index Cond: (id = documents0_.document_id)
  • Buffers: shared hit=66
Planning time : 0.324 ms
Execution time : 530.018 ms