explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QfPI

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 28.161 ↓ 0.0 0 1

Unique (cost=2,950.15..2,951.15 rows=4 width=8) (actual time=28.161..28.161 rows=0 loops=1)

  • Buffers: shared hit=1,077
2. 0.036 28.161 ↓ 0.0 0 1

Sort (cost=2,950.15..2,950.65 rows=201 width=8) (actual time=28.16..28.161 rows=0 loops=1)

  • Sort Key: t_e20so1_document.c_datasetid
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1,077
3. 0.008 28.125 ↓ 0.0 0 1

Hash Join (cost=2,450.14..2,942.46 rows=201 width=8) (actual time=28.124..28.125 rows=0 loops=1)

  • Buffers: shared hit=1,074
4. 0.031 0.031 ↑ 16,304.0 1 1

Seq Scan on t_t71wx3_jobbatchdocument_similarityindexing t_t71wx3_jobbatchdocument_SimilarityIndexing (cost=0..408.8 rows=16,304 width=8) (actual time=0.031..0.031 rows=1 loops=1)

  • Filter: ("t_t71wx3_jobbatchdocument_SimilarityIndexing".c_servicetype = 209)
  • Buffers: shared hit=1
5. 0.001 28.086 ↓ 0.0 0 1

Hash (cost=2,448.86..2,448.86 rows=102 width=40) (actual time=28.085..28.086 rows=0 loops=1)

  • Buffers: shared hit=1,073
6. 0.007 28.085 ↓ 0.0 0 1

Hash Join (cost=2,172.47..2,448.86 rows=102 width=40) (actual time=28.085..28.085 rows=0 loops=1)

  • Buffers: shared hit=1,073
7. 0.028 0.028 ↑ 8,364.0 1 1

Seq Scan on t_t71wx3_jobbatchdocument_entityrecognition t_t71wx3_jobbatchdocument_EntityRecognition (cost=0..233.55 rows=8,364 width=8) (actual time=0.028..0.028 rows=1 loops=1)

  • Filter: ("t_t71wx3_jobbatchdocument_EntityRecognition".c_servicetype = 212)
  • Buffers: shared hit=1
8. 0.001 28.050 ↓ 0.0 0 1

Hash (cost=2,171.39..2,171.39 rows=87 width=32) (actual time=28.05..28.05 rows=0 loops=1)

  • Buffers: shared hit=1,072
9. 0.723 28.049 ↓ 0.0 0 1

Hash Join (cost=1,929.44..2,171.39 rows=87 width=32) (actual time=28.049..28.049 rows=0 loops=1)

  • Buffers: shared hit=1,072
10. 2.105 2.105 ↑ 1.0 7,033 1

Seq Scan on t_t71wx3_jobbatchdocument_similaritysearch t_t71wx3_jobbatchdocument_SimilaritySearch (cost=0..205.91 rows=7,033 width=8) (actual time=0.009..2.105 rows=7,033 loops=1)

  • Filter: ("t_t71wx3_jobbatchdocument_SimilaritySearch".c_servicetype = 202)
  • Buffers: shared hit=118
11. 0.030 25.221 ↓ 1.3 94 1

Hash (cost=1,928.55..1,928.55 rows=71 width=24) (actual time=25.221..25.221 rows=94 loops=1)

  • Buffers: shared hit=954
12. 6.154 25.191 ↓ 1.3 94 1

Hash Join (cost=4.17..1,928.55 rows=71 width=24) (actual time=3.396..25.191 rows=94 loops=1)

  • Buffers: shared hit=954
13. 18.998 18.998 ↑ 1.0 64,354 1

Seq Scan on t_t71wx3_jobbatchdocument_indexing t_t71wx3_jobbatchdocument_indexing (cost=0..1,755.43 rows=64,354 width=8) (actual time=0.023..18.998 rows=64,354 loops=1)

  • Filter: (t_t71wx3_jobbatchdocument_indexing.c_servicetype = 201)
  • Buffers: shared hit=951
14. 0.011 0.039 ↑ 1.0 47 1

Hash (cost=3.59..3.59 rows=47 width=16) (actual time=0.038..0.039 rows=47 loops=1)

  • Buffers: shared hit=3
15. 0.028 0.028 ↑ 1.0 47 1

Seq Scan on t_e20so1_document_datastore_12 t_e20so1_document (cost=0..3.59 rows=47 width=16) (actual time=0.012..0.028 rows=47 loops=1)

  • Filter: (t_e20so1_document.c_datastoresid = 12)
  • Buffers: shared hit=3
Planning time : 3.765 ms
Execution time : 28.396 ms