explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jpAuz

Settings
# exclusive inclusive rows x rows loops node
1. 2,155.430 5,171.166 ↑ 11.9 995,149 1

Hash Join (cost=191.53..2,124,121.41 rows=11,807,049 width=26) (actual time=4.965..5,171.166 rows=995,149 loops=1)

  • Hash Cond: ((dmf.external_field_name)::text = (emf.external_merge_field_name)::text)
2. 3,014.894 3,014.894 ↓ 1.0 10,913,317 1

Index Scan using idx_document_merge_fields_cid_document_id_document_addenda_id on document_merge_fields dmf (cost=0.56..918,955.87 rows=10,803,341 width=50) (actual time=0.051..3,014.894 rows=10,913,317 loops=1)

  • Index Cond: ((cid = 1,826) AND (document_id = ANY ('{196536,196526,196553,196587,196591,196623,196642,196658,196710,196712,196725,196736,196740,196762,196777}'::integer[])))
3. 0.379 0.842 ↑ 1.0 2,445 1

Hash (cost=110.85..110.85 rows=2,465 width=26) (actual time=0.842..0.842 rows=2,445 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 163kB
4. 0.463 0.463 ↑ 1.0 2,445 1

Index Only Scan using idx_external_merge_fields_data_type_external_field_name on external_merge_fields emf (cost=0.41..110.85 rows=2,465 width=26) (actual time=0.047..0.463 rows=2,445 loops=1)

  • Index Cond: (data_type = 'date'::text)
  • Heap Fetches: 0
Planning time : 1.318 ms
Execution time : 5,212.011 ms