explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3B6O

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 69,366.965 ↑ 3.0 10 1

Unique (cost=5,917,127.15..5,917,130.23 rows=30 width=726) (actual time=69,366.956..69,366.965 rows=10 loops=1)

  • Output: x0.keyfaersdemographic, x0.mpfdaage, x3.mpfdaagecode, x4.mpfdaagegroupcode, x0.mpfdaauthnum, x0.mpfdacaseid, x0.mpfdacaseversion, x0.mpfdaconfid, x0.mpfdadeathdt, x0.mpfdaesub, x0.mpfdaeventdt, x0.mpfdafdadt, x0.mpfdafollseq, x0.mpfdaimage, x0.mpfdainitdt, x0.mpfdalitref, x0.mpfdamfrdt, x0.mpfdamfrnum, x0.mpfdamfrsndr, x0.mpfdaoccrcountry, x7.mpfdaoccupationcode, x5.mpfdapatientgendercode, x0.mpfdapatientweight, x6.mpfdapatientweightcode, x0.mpfdareportercountry, x1.mpfdareportstatuscode, x2.mpfdareporttypecode, x0.mpfdareptdt, x0.mpfdatomfr, x0.keympfdaprimaryid, t1_0.keyaioidconfidencemapping, t1_0.aioidmappingasof, t1_0.batchsequence, t1_0.confidencerank, t1_0.keyaimodelversion, t1_0.keyminamespace, t1_0.keytable, t1_0.matchconfidence, t1_0.oid, t1_0.oidvendor, x0.keyfaersdemographic
  • Buffers: shared hit=440163, temp read=67608 written=215411
2.          

CTE cte_base_1

3. 2,415.305 20,044.436 ↓ 1.0 13,161,010 1

Unique (cost=0.56..2,037,842.86 rows=13,158,587 width=32) (actual time=0.032..20,044.436 rows=13,161,010 loops=1)

  • Output: x0_1.keyfaersdemographic, x0_1.keyfaersdemographic
  • Buffers: shared hit=55359
4. 17,629.131 17,629.131 ↓ 1.0 13,161,010 1

Index Scan using pk_faersdemographic on mpdata.faersdemographic x0_1 (cost=0.56..2,004,946.39 rows=13,158,587 width=32) (actual time=0.028..17,629.131 rows=13,161,010 loops=1)

  • Output: x0_1.keyfaersdemographic, x0_1.keyfaersdemographic
  • Filter: ((x0_1.updoperation < 2) AND (x0_1.updoperation < 2))
  • Buffers: shared hit=55359
5.          

CTE cte_dstnctbase_2

6. 5,026.137 34,876.349 ↓ 1.0 13,161,010 1

WindowAgg (cost=2,448,805.84..2,711,977.58 rows=13,158,587 width=40) (actual time=28,753.640..34,876.349 rows=13,161,010 loops=1)

  • Output: row_number() OVER (?), cte_base_1."1", cte_base_1."2
  • Buffers: shared hit=55359, temp read=67608 written=135083
7. 7,223.326 29,850.212 ↓ 1.0 13,161,010 1

Sort (cost=2,448,805.84..2,481,702.31 rows=13,158,587 width=32) (actual time=28,753.633..29,850.212 rows=13,161,010 loops=1)

  • Output: cte_base_1."1", cte_base_1."2
  • Sort Key: cte_base_1."1", cte_base_1."2
  • Sort Method: external sort Disk: 540864kB
  • Buffers: shared hit=55359, temp read=67608 written=135083
8. 22,626.886 22,626.886 ↓ 1.0 13,161,010 1

CTE Scan on cte_base_1 (cost=0.00..263,171.74 rows=13,158,587 width=32) (actual time=0.032..22,626.886 rows=13,161,010 loops=1)

  • Output: cte_base_1."1", cte_base_1."2
  • Buffers: shared hit=55359, temp written=67475
9.          

CTE cte_dstnct_2

10. 0.002 40,731.818 ↑ 1.0 2 1

Limit (cost=296,726.14..296,726.14 rows=2 width=32) (actual time=40,731.817..40,731.818 rows=2 loops=1)

  • Output: cte_dstnctbase_2."1", cte_dstnctbase_2."2
  • Buffers: shared hit=55359, temp read=67608 written=215411
11. 1,510.395 40,731.816 ↑ 32,896.5 2 1

Sort (cost=296,726.14..296,890.62 rows=65,793 width=32) (actual time=40,731.815..40,731.816 rows=2 loops=1)

  • Output: cte_dstnctbase_2."1", cte_dstnctbase_2."2
  • Sort Key: cte_dstnctbase_2."2
  • Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared hit=55359, temp read=67608 written=215411
12. 39,221.421 39,221.421 ↓ 200.0 13,161,010 1

CTE Scan on cte_dstnctbase_2 (cost=0.00..296,068.21 rows=65,793 width=32) (actual time=28,753.641..39,221.421 rows=13,161,010 loops=1)

  • Output: cte_dstnctbase_2."1", cte_dstnctbase_2."2
  • Filter: (cte_dstnctbase_2.rownumber = 1)
  • Buffers: shared hit=55359, temp read=67608 written=215411
13. 0.054 69,366.949 ↑ 3.0 10 1

Sort (cost=870,580.58..870,580.65 rows=30 width=726) (actual time=69,366.948..69,366.949 rows=10 loops=1)

  • Output: x0.keyfaersdemographic, x0.mpfdaage, x3.mpfdaagecode, x4.mpfdaagegroupcode, x0.mpfdaauthnum, x0.mpfdacaseid, x0.mpfdacaseversion, x0.mpfdaconfid, x0.mpfdadeathdt, x0.mpfdaesub, x0.mpfdaeventdt, x0.mpfdafdadt, x0.mpfdafollseq, x0.mpfdaimage, x0.mpfdainitdt, x0.mpfdalitref, x0.mpfdamfrdt, x0.mpfdamfrnum, x0.mpfdamfrsndr, x0.mpfdaoccrcountry, x7.mpfdaoccupationcode, x5.mpfdapatientgendercode, x0.mpfdapatientweight, x6.mpfdapatientweightcode, x0.mpfdareportercountry, x1.mpfdareportstatuscode, x2.mpfdareporttypecode, x0.mpfdareptdt, x0.mpfdatomfr, x0.keympfdaprimaryid, t1_0.keyaioidconfidencemapping, t1_0.aioidmappingasof, t1_0.batchsequence, t1_0.confidencerank, t1_0.keyaimodelversion, t1_0.keyminamespace, t1_0.keytable, t1_0.matchconfidence, t1_0.oid, t1_0.oidvendor, x0.keyfaersdemographic
  • Sort Key: x0.keyfaersdemographic, t1_0.keyaioidconfidencemapping, x0.mpfdaage, x3.mpfdaagecode, x4.mpfdaagegroupcode, x0.mpfdaauthnum, x0.mpfdacaseid, x0.mpfdacaseversion, x0.mpfdaconfid, x0.mpfdadeathdt, x0.mpfdaesub, x0.mpfdaeventdt, x0.mpfdafdadt, x0.mpfdafollseq, x0.mpfdaimage, x0.mpfdainitdt, x0.mpfdalitref, x0.mpfdamfrdt, x0.mpfdamfrnum, x0.mpfdamfrsndr, x0.mpfdaoccrcountry, x7.mpfdaoccupationcode, x5.mpfdapatientgendercode, x0.mpfdapatientweight, x6.mpfdapatientweightcode, x0.mpfdareportercountry, x1.mpfdareportstatuscode, x2.mpfdareporttypecode, x0.mpfdareptdt, x0.mpfdatomfr, x0.keympfdaprimaryid, t1_0.aioidmappingasof, t1_0.batchsequence, t1_0.confidencerank, t1_0.keyaimodelversion, t1_0.keyminamespace, t1_0.keytable, t1_0.matchconfidence, t1_0.oid, t1_0.oidvendor
  • Sort Method: quicksort Memory: 27kB
  • Buffers: shared hit=440163, temp read=67608 written=215411
14. 0.020 69,366.895 ↑ 3.0 10 1

Nested Loop Left Join (cost=66.55..870,579.84 rows=30 width=726) (actual time=44,597.977..69,366.895 rows=10 loops=1)

  • Output: x0.keyfaersdemographic, x0.mpfdaage, x3.mpfdaagecode, x4.mpfdaagegroupcode, x0.mpfdaauthnum, x0.mpfdacaseid, x0.mpfdacaseversion, x0.mpfdaconfid, x0.mpfdadeathdt, x0.mpfdaesub, x0.mpfdaeventdt, x0.mpfdafdadt, x0.mpfdafollseq, x0.mpfdaimage, x0.mpfdainitdt, x0.mpfdalitref, x0.mpfdamfrdt, x0.mpfdamfrnum, x0.mpfdamfrsndr, x0.mpfdaoccrcountry, x7.mpfdaoccupationcode, x5.mpfdapatientgendercode, x0.mpfdapatientweight, x6.mpfdapatientweightcode, x0.mpfdareportercountry, x1.mpfdareportstatuscode, x2.mpfdareporttypecode, x0.mpfdareptdt, x0.mpfdatomfr, x0.keympfdaprimaryid, t1_0.keyaioidconfidencemapping, t1_0.aioidmappingasof, t1_0.batchsequence, t1_0.confidencerank, t1_0.keyaimodelversion, t1_0.keyminamespace, t1_0.keytable, t1_0.matchconfidence, t1_0.oid, t1_0.oidvendor, x0.keyfaersdemographic
  • Buffers: shared hit=440163, temp read=67608 written=215411
15. 1,522.211 69,366.821 ↑ 1.0 2 1

Hash Semi Join (cost=65.99..870,577.63 rows=2 width=650) (actual time=44,597.942..69,366.821 rows=2 loops=1)

  • Output: x0.keyfaersdemographic, x0.mpfdaage, x0.mpfdaauthnum, x0.mpfdacaseid, x0.mpfdacaseversion, x0.mpfdaconfid, x0.mpfdadeathdt, x0.mpfdaesub, x0.mpfdaeventdt, x0.mpfdafdadt, x0.mpfdafollseq, x0.mpfdaimage, x0.mpfdainitdt, x0.mpfdalitref, x0.mpfdamfrdt, x0.mpfdamfrnum, x0.mpfdamfrsndr, x0.mpfdaoccrcountry, x0.mpfdapatientweight, x0.mpfdareportercountry, x0.mpfdareptdt, x0.mpfdatomfr, x0.keympfdaprimaryid, x1.mpfdareportstatuscode, x2.mpfdareporttypecode, x3.mpfdaagecode, x4.mpfdaagegroupcode, x5.mpfdapatientgendercode, x6.mpfdapatientweightcode, x7.mpfdaoccupationcode
  • Hash Cond: (x0.keyfaersdemographic = cte_dstnct_2."1")
  • Buffers: shared hit=440153, temp read=67608 written=215411
16. 3,464.798 27,112.780 ↓ 1.0 13,161,010 1

Hash Left Join (cost=65.93..836,036.26 rows=13,158,587 width=650) (actual time=0.175..27,112.780 rows=13,161,010 loops=1)

  • Output: x0.keyfaersdemographic, x0.mpfdaage, x0.mpfdaauthnum, x0.mpfdacaseid, x0.mpfdacaseversion, x0.mpfdaconfid, x0.mpfdadeathdt, x0.mpfdaesub, x0.mpfdaeventdt, x0.mpfdafdadt, x0.mpfdafollseq, x0.mpfdaimage, x0.mpfdainitdt, x0.mpfdalitref, x0.mpfdamfrdt, x0.mpfdamfrnum, x0.mpfdamfrsndr, x0.mpfdaoccrcountry, x0.mpfdapatientweight, x0.mpfdareportercountry, x0.mpfdareptdt, x0.mpfdatomfr, x0.keympfdaprimaryid, x1.mpfdareportstatuscode, x2.mpfdareporttypecode, x3.mpfdaagecode, x4.mpfdaagegroupcode, x5.mpfdapatientgendercode, x6.mpfdapatientweightcode, x7.mpfdaoccupationcode
  • Inner Unique: true
  • Hash Cond: (x0.keyfaersoccupationcode = x7.keyfaersoccupationcode)
  • Buffers: shared hit=384794
17. 3,099.740 23,647.969 ↓ 1.0 13,161,010 1

Hash Left Join (cost=53.59..800,498.37 rows=13,158,587 width=630) (actual time=0.153..23,647.969 rows=13,161,010 loops=1)

  • Output: x0.keyfaersdemographic, x0.mpfdaage, x0.mpfdaauthnum, x0.mpfdacaseid, x0.mpfdacaseversion, x0.mpfdaconfid, x0.mpfdadeathdt, x0.mpfdaesub, x0.mpfdaeventdt, x0.mpfdafdadt, x0.mpfdafollseq, x0.mpfdaimage, x0.mpfdainitdt, x0.mpfdalitref, x0.mpfdamfrdt, x0.mpfdamfrnum, x0.mpfdamfrsndr, x0.mpfdaoccrcountry, x0.mpfdapatientweight, x0.mpfdareportercountry, x0.mpfdareptdt, x0.mpfdatomfr, x0.keympfdaprimaryid, x0.keyfaersoccupationcode, x1.mpfdareportstatuscode, x2.mpfdareporttypecode, x3.mpfdaagecode, x4.mpfdaagegroupcode, x5.mpfdapatientgendercode, x6.mpfdapatientweightcode
  • Inner Unique: true
  • Hash Cond: (x0.keyfaerspatientweightcode = x6.keyfaerspatientweightcode)
  • Buffers: shared hit=384793
18. 3,329.520 20,548.216 ↓ 1.0 13,161,010 1

Hash Left Join (cost=52.10..764,748.97 rows=13,158,587 width=576) (actual time=0.131..20,548.216 rows=13,161,010 loops=1)

  • Output: x0.keyfaersdemographic, x0.mpfdaage, x0.mpfdaauthnum, x0.mpfdacaseid, x0.mpfdacaseversion, x0.mpfdaconfid, x0.mpfdadeathdt, x0.mpfdaesub, x0.mpfdaeventdt, x0.mpfdafdadt, x0.mpfdafollseq, x0.mpfdaimage, x0.mpfdainitdt, x0.mpfdalitref, x0.mpfdamfrdt, x0.mpfdamfrnum, x0.mpfdamfrsndr, x0.mpfdaoccrcountry, x0.mpfdapatientweight, x0.mpfdareportercountry, x0.mpfdareptdt, x0.mpfdatomfr, x0.keympfdaprimaryid, x0.keyfaerspatientweightcode, x0.keyfaersoccupationcode, x1.mpfdareportstatuscode, x2.mpfdareporttypecode, x3.mpfdaagecode, x4.mpfdaagegroupcode, x5.mpfdapatientgendercode
  • Inner Unique: true
  • Hash Cond: (x0.keyfaerspatientgender = x5.keyfaerspatientgender)
  • Buffers: shared hit=384792
19. 3,176.918 17,218.686 ↓ 1.0 13,161,010 1

Hash Left Join (cost=50.75..723,876.74 rows=13,158,587 width=556) (actual time=0.110..17,218.686 rows=13,161,010 loops=1)

  • Output: x0.keyfaersdemographic, x0.mpfdaage, x0.mpfdaauthnum, x0.mpfdacaseid, x0.mpfdacaseversion, x0.mpfdaconfid, x0.mpfdadeathdt, x0.mpfdaesub, x0.mpfdaeventdt, x0.mpfdafdadt, x0.mpfdafollseq, x0.mpfdaimage, x0.mpfdainitdt, x0.mpfdalitref, x0.mpfdamfrdt, x0.mpfdamfrnum, x0.mpfdamfrsndr, x0.mpfdaoccrcountry, x0.mpfdapatientweight, x0.mpfdareportercountry, x0.mpfdareptdt, x0.mpfdatomfr, x0.keympfdaprimaryid, x0.keyfaerspatientgender, x0.keyfaerspatientweightcode, x0.keyfaersoccupationcode, x1.mpfdareportstatuscode, x2.mpfdareporttypecode, x3.mpfdaagecode, x4.mpfdaagegroupcode
  • Inner Unique: true
  • Hash Cond: (x0.keyfaersagegroup = x4.keyfaersagegroup)
  • Buffers: shared hit=384791
20. 3,259.676 14,041.759 ↓ 1.0 13,161,010 1

Hash Left Join (cost=34.91..689,271.25 rows=13,158,587 width=512) (actual time=0.087..14,041.759 rows=13,161,010 loops=1)

  • Output: x0.keyfaersdemographic, x0.mpfdaage, x0.mpfdaauthnum, x0.mpfdacaseid, x0.mpfdacaseversion, x0.mpfdaconfid, x0.mpfdadeathdt, x0.mpfdaesub, x0.mpfdaeventdt, x0.mpfdafdadt, x0.mpfdafollseq, x0.mpfdaimage, x0.mpfdainitdt, x0.mpfdalitref, x0.mpfdamfrdt, x0.mpfdamfrnum, x0.mpfdamfrsndr, x0.mpfdaoccrcountry, x0.mpfdapatientweight, x0.mpfdareportercountry, x0.mpfdareptdt, x0.mpfdatomfr, x0.keympfdaprimaryid, x0.keyfaersagegroup, x0.keyfaerspatientgender, x0.keyfaerspatientweightcode, x0.keyfaersoccupationcode, x1.mpfdareportstatuscode, x2.mpfdareporttypecode, x3.mpfdaagecode
  • Inner Unique: true
  • Hash Cond: (x0.keyfaersagecode = x3.keyfaersagecode)
  • Buffers: shared hit=384790
21. 3,342.847 10,782.067 ↓ 1.0 13,161,010 1

Hash Left Join (cost=33.33..652,017.80 rows=13,158,587 width=484) (actual time=0.061..10,782.067 rows=13,161,010 loops=1)

  • Output: x0.keyfaersdemographic, x0.mpfdaage, x0.mpfdaauthnum, x0.mpfdacaseid, x0.mpfdacaseversion, x0.mpfdaconfid, x0.mpfdadeathdt, x0.mpfdaesub, x0.mpfdaeventdt, x0.mpfdafdadt, x0.mpfdafollseq, x0.mpfdaimage, x0.mpfdainitdt, x0.mpfdalitref, x0.mpfdamfrdt, x0.mpfdamfrnum, x0.mpfdamfrsndr, x0.mpfdaoccrcountry, x0.mpfdapatientweight, x0.mpfdareportercountry, x0.mpfdareptdt, x0.mpfdatomfr, x0.keympfdaprimaryid, x0.keyfaersagecode, x0.keyfaersagegroup, x0.keyfaerspatientgender, x0.keyfaerspatientweightcode, x0.keyfaersoccupationcode, x1.mpfdareportstatuscode, x2.mpfdareporttypecode
  • Inner Unique: true
  • Hash Cond: (x0.keyfaersreporttype = x2.keyfaersreporttype)
  • Buffers: shared hit=384789
22. 3,390.583 7,439.209 ↓ 1.0 13,161,010 1

Hash Left Join (cost=17.16..617,064.69 rows=13,158,587 width=452) (actual time=0.037..7,439.209 rows=13,161,010 loops=1)

  • Output: x0.keyfaersdemographic, x0.mpfdaage, x0.mpfdaauthnum, x0.mpfdacaseid, x0.mpfdacaseversion, x0.mpfdaconfid, x0.mpfdadeathdt, x0.mpfdaesub, x0.mpfdaeventdt, x0.mpfdafdadt, x0.mpfdafollseq, x0.mpfdaimage, x0.mpfdainitdt, x0.mpfdalitref, x0.mpfdamfrdt, x0.mpfdamfrnum, x0.mpfdamfrsndr, x0.mpfdaoccrcountry, x0.mpfdapatientweight, x0.mpfdareportercountry, x0.mpfdareptdt, x0.mpfdatomfr, x0.keympfdaprimaryid, x0.keyfaersreporttype, x0.keyfaersagecode, x0.keyfaersagegroup, x0.keyfaerspatientgender, x0.keyfaerspatientweightcode, x0.keyfaersoccupationcode, x1.mpfdareportstatuscode
  • Inner Unique: true
  • Hash Cond: (x0.keyfaersreportstatus = x1.keyfaersreportstatus)
  • Buffers: shared hit=384788
23. 4,048.614 4,048.614 ↓ 1.0 13,161,010 1

Seq Scan on mpdata.faersdemographic x0 (cost=0.00..582,165.80 rows=13,158,587 width=448) (actual time=0.011..4,048.614 rows=13,161,010 loops=1)

  • Output: x0.keyfaersdemographic, x0.keympfdaprimaryid, x0.mpfdacaseid, x0.mpfdacaseversion, x0.mpfdaeventdt, x0.mpfdamfrdt, x0.mpfdainitdt, x0.mpfdafdadt, x0.mpfdaauthnum, x0.mpfdamfrnum, x0.mpfdamfrsndr, x0.mpfdalitref, x0.mpfdareptdt, x0.mpfdareportercountry, x0.mpfdaoccrcountry, x0.mpfdaimage, x0.mpfdadeathdt, x0.mpfdafollseq, x0.mpfdaage, x0.keyfaersagecode, x0.keyfaersagegroup, x0.mpfdapatientweight, x0.keyfaerspatientweightcode, x0.keyfaerspatientgender, x0.keyfaersreportstatus, x0.keyfaersreporttype, x0.keyfaersoccupationcode, x0.mpfdaesub, x0.mpfdatomfr, x0.mpfdaconfid, x0.updoperation, x0.upddate, x0.mpfdafilename, x0.mpfdasequencenumber
  • Filter: ((x0.updoperation < 2) AND (x0.updoperation < 2))
  • Buffers: shared hit=384787
24. 0.006 0.012 ↑ 11.0 13 1

Hash (cost=15.38..15.38 rows=143 width=12) (actual time=0.012..0.012 rows=13 loops=1)

  • Output: x1.mpfdareportstatuscode, x1.keyfaersreportstatus
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
25. 0.006 0.006 ↑ 11.0 13 1

Seq Scan on mpdata.faersreportstatus x1 (cost=0.00..15.38 rows=143 width=12) (actual time=0.004..0.006 rows=13 loops=1)

  • Output: x1.mpfdareportstatuscode, x1.keyfaersreportstatus
  • Filter: (x1.updoperation < 2)
  • Buffers: shared hit=1
26. 0.005 0.011 ↑ 6.8 18 1

Hash (cost=14.62..14.62 rows=123 width=40) (actual time=0.011..0.011 rows=18 loops=1)

  • Output: x2.mpfdareporttypecode, x2.keyfaersreporttype
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
27. 0.006 0.006 ↑ 6.8 18 1

Seq Scan on mpdata.faersreporttype x2 (cost=0.00..14.62 rows=123 width=40) (actual time=0.003..0.006 rows=18 loops=1)

  • Output: x2.mpfdareporttypecode, x2.keyfaersreporttype
  • Filter: (x2.updoperation < 2)
  • Buffers: shared hit=1
28. 0.008 0.016 ↓ 2.9 35 1

Hash (cost=1.44..1.44 rows=12 width=36) (actual time=0.016..0.016 rows=35 loops=1)

  • Output: x3.mpfdaagecode, x3.keyfaersagecode
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
29. 0.008 0.008 ↓ 2.9 35 1

Seq Scan on mpdata.faersagecode x3 (cost=0.00..1.44 rows=12 width=36) (actual time=0.003..0.008 rows=35 loops=1)

  • Output: x3.mpfdaagecode, x3.keyfaersagecode
  • Filter: (x3.updoperation < 2)
  • Buffers: shared hit=1
30. 0.004 0.009 ↑ 6.5 18 1

Hash (cost=14.38..14.38 rows=117 width=52) (actual time=0.009..0.009 rows=18 loops=1)

  • Output: x4.mpfdaagegroupcode, x4.keyfaersagegroup
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
31. 0.005 0.005 ↑ 6.5 18 1

Seq Scan on mpdata.faersagegroup x4 (cost=0.00..14.38 rows=117 width=52) (actual time=0.003..0.005 rows=18 loops=1)

  • Output: x4.mpfdaagegroupcode, x4.keyfaersagegroup
  • Filter: (x4.updoperation < 2)
  • Buffers: shared hit=1
32. 0.004 0.010 ↓ 3.0 21 1

Hash (cost=1.26..1.26 rows=7 width=28) (actual time=0.010..0.010 rows=21 loops=1)

  • Output: x5.mpfdapatientgendercode, x5.keyfaerspatientgender
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
33. 0.006 0.006 ↓ 3.0 21 1

Seq Scan on mpdata.faerspatientgender x5 (cost=0.00..1.26 rows=7 width=28) (actual time=0.003..0.006 rows=21 loops=1)

  • Output: x5.mpfdapatientgendercode, x5.keyfaerspatientgender
  • Filter: (x5.updoperation < 2)
  • Buffers: shared hit=1
34. 0.006 0.013 ↓ 2.9 29 1

Hash (cost=1.36..1.36 rows=10 width=62) (actual time=0.013..0.013 rows=29 loops=1)

  • Output: x6.mpfdapatientweightcode, x6.keyfaerspatientweightcode
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
35. 0.007 0.007 ↓ 2.9 29 1

Seq Scan on mpdata.faerspatientweightcode x6 (cost=0.00..1.36 rows=10 width=62) (actual time=0.004..0.007 rows=29 loops=1)

  • Output: x6.mpfdapatientweightcode, x6.keyfaerspatientweightcode
  • Filter: (x6.updoperation < 2)
  • Buffers: shared hit=1
36. 0.006 0.013 ↑ 2.2 21 1

Hash (cost=11.75..11.75 rows=47 width=28) (actual time=0.013..0.013 rows=21 loops=1)

  • Output: x7.mpfdaoccupationcode, x7.keyfaersoccupationcode
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
37. 0.007 0.007 ↑ 2.2 21 1

Seq Scan on mpdata.faersoccupationcode x7 (cost=0.00..11.75 rows=47 width=28) (actual time=0.004..0.007 rows=21 loops=1)

  • Output: x7.mpfdaoccupationcode, x7.keyfaersoccupationcode
  • Filter: (x7.updoperation < 2)
  • Buffers: shared hit=1
38. 0.010 40,731.830 ↑ 1.0 2 1

Hash (cost=0.04..0.04 rows=2 width=16) (actual time=40,731.829..40,731.830 rows=2 loops=1)

  • Output: cte_dstnct_2."1
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=55359, temp read=67608 written=215411
39. 40,731.820 40,731.820 ↑ 1.0 2 1

CTE Scan on cte_dstnct_2 (cost=0.00..0.04 rows=2 width=16) (actual time=40,731.818..40,731.820 rows=2 loops=1)

  • Output: cte_dstnct_2."1
  • Buffers: shared hit=55359, temp read=67608 written=215411
40. 0.054 0.054 ↑ 3.0 5 2

Index Scan using ai_aioidconfidencemapping_26071 on calcs2.aioidconfidencemapping t1_0 (cost=0.56..0.95 rows=15 width=60) (actual time=0.026..0.027 rows=5 loops=2)

  • Output: t1_0.keyaioidconfidencemapping, t1_0.keytable, t1_0.oid, t1_0.oidvendor, t1_0.keyminamespace, t1_0.keyaimodelversion, t1_0.matchconfidence, t1_0.confidencerank, t1_0.aioidmappingasof, t1_0.batchsequence, t1_0.updoperation, t1_0.upddate
  • Index Cond: ((t1_0.keytable = 117) AND (t1_0.keyminamespace = 67) AND ((x0.mpfdamfrsndr)::text = (t1_0.oidvendor)::text))
  • Buffers: shared hit=10
Planning time : 5.905 ms
Execution time : 69,618.240 ms