explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FRcS : Optimization for: plan #e1Ky

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 7.484 54.160 ↑ 1.2 24 1

HashAggregate (cost=3,697.93..3,698.23 rows=30 width=8) (actual time=54.156..54.16 rows=24 loops=1)

  • Group Key: t_e20so1_document.c_datasetid
  • Buffers: shared hit=453
2. 17.890 46.676 ↑ 1.0 43,814 1

Hash Join (cost=335.26..3,587.75 rows=44,069 width=8) (actual time=3.634..46.676 rows=43,814 loops=1)

  • Buffers: shared hit=453
3. 9.173 25.212 ↑ 1.0 96,055 1

Append (cost=0.29..2,451.89 rows=96,055 width=8) (actual time=0.032..25.212 rows=96,055 loops=1)

  • Buffers: shared hit=410
4. 10.647 10.647 ↑ 1.0 64,354 1

Index Only Scan using t_t71wx3_jobbatchdocument_indexing_c_servicetype_c_recordid_idx on t_t71wx3_jobbatchdocument_indexing t_t71wx3_jobbatchdocument (cost=0.29..1,311.35 rows=64,354 width=8) (actual time=0.031..10.647 rows=64,354 loops=1)

  • Index Cond: (t_t71wx3_jobbatchdocument.c_servicetype = ANY ('{212,202,214,201,209}'::integer[]))
  • Buffers: shared hit=257
5. 1.317 1.317 ↑ 1.0 7,033 1

Index Only Scan using t_t71wx3_jobbatchdocument_similari_c_servicetype_c_recordid_idx on t_t71wx3_jobbatchdocument_similaritysearch t_t71wx3_jobbatchdocument_1 (cost=0.28..146.5 rows=7,033 width=8) (actual time=0.037..1.317 rows=7,033 loops=1)

  • Index Cond: (t_t71wx3_jobbatchdocument_1.c_servicetype = ANY ('{212,202,214,201,209}'::integer[]))
  • Buffers: shared hit=37
6. 2.698 2.698 ↑ 1.0 16,304 1

Index Only Scan using t_t71wx3_jobbatchdocument_similar_c_servicetype_c_recordid_idx1 on t_t71wx3_jobbatchdocument_similarityindexing t_t71wx3_jobbatchdocument_2 (cost=0.29..337.35 rows=16,304 width=8) (actual time=0.04..2.698 rows=16,304 loops=1)

  • Index Cond: (t_t71wx3_jobbatchdocument_2.c_servicetype = ANY ('{212,202,214,201,209}'::integer[]))
  • Buffers: shared hit=73
7. 1.377 1.377 ↑ 1.0 8,364 1

Index Only Scan using t_t71wx3_jobbatchdocument_entityre_c_servicetype_c_recordid_idx on t_t71wx3_jobbatchdocument_entityrecognition t_t71wx3_jobbatchdocument_3 (cost=0.29..176.4 rows=8,364 width=8) (actual time=0.041..1.377 rows=8,364 loops=1)

  • Index Cond: (t_t71wx3_jobbatchdocument_3.c_servicetype = ANY ('{212,202,214,201,209}'::integer[]))
  • Buffers: shared hit=43
8. 1.338 3.574 ↑ 1.0 8,211 1

Hash (cost=232.33..232.33 rows=8,211 width=16) (actual time=3.574..3.574 rows=8,211 loops=1)

  • Buffers: shared hit=43
9. 0.766 2.236 ↑ 1.0 8,211 1

Append (cost=0.29..232.33 rows=8,211 width=16) (actual time=0.02..2.236 rows=8,211 loops=1)

  • Buffers: shared hit=43
10. 1.470 1.470 ↑ 1.0 8,211 1

Index Only Scan using t_e20so1_document_datastore_1_c_datastoresid_c_documentid__idx1 on t_e20so1_document_datastore_11 t_e20so1_document (cost=0.29..191.28 rows=8,211 width=16) (actual time=0.02..1.47 rows=8,211 loops=1)

  • Index Cond: (t_e20so1_document.c_datastoresid = 11)
  • Buffers: shared hit=43
Planning time : 2.074 ms
Execution time : 54.354 ms