explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bwwK

Settings
# exclusive inclusive rows x rows loops node
1. 20.138 967.424 ↓ 1.0 11,827 1

Gather (cost=6,827.67..26,812.9 rows=11,814 width=200) (actual time=415.485..967.424 rows=11,827 loops=1)

  • Buffers: shared hit=60095 read=3113
2. 0.706 947.286 ↑ 1.2 3,942 3

Hash Join (cost=5,827.67..24,631.5 rows=4,922 width=200) (actual time=414.698..947.286 rows=3,942 loops=3)

  • Buffers: shared hit=60095 read=3113
3. 0.687 946.390 ↑ 1.2 3,942 3

Hash Join (cost=5,817.08..24,607.8 rows=4,922 width=204) (actual time=414.447..946.39 rows=3,942 loops=3)

  • Buffers: shared hit=59994 read=3111
4. 327.918 945.654 ↑ 1.2 3,942 3

Nested Loop (cost=5,806.49..24,584.1 rows=4,922 width=208) (actual time=414.377..945.654 rows=3,942 loops=3)

  • Buffers: shared hit=59982 read=3111
5. 2.053 617.653 ↑ 1.3 3,942 3

Merge Join (cost=5,806.07..18,339.37 rows=4,928 width=123) (actual time=401.802..617.653 rows=3,942 loops=3)

  • Buffers: shared hit=13039 read=2744
6. 260.416 260.416 ↑ 6.5 17,261 3

Index Scan using bib_citation_cache_pkey on bib_citation_cache c (cost=0.42..12,697.43 rows=112,364 width=64) (actual time=47.196..260.416 rows=17,261 loops=3)

  • Buffers: shared hit=76 read=1450
7. 3.950 355.184 ↑ 1.0 11,827 3

Sort (cost=5,805.62..5,835.19 rows=11,827 width=59) (actual time=354.452..355.184 rows=11,827 loops=3)

  • Sort Key: x._refs_key
  • Sort Method: quicksort Memory: 2048kB
  • Buffers: shared hit=12963 read=1294
8. 2.023 351.234 ↑ 1.0 11,827 3

Hash Join (cost=734.8..5,005.54 rows=11,827 width=59) (actual time=15.781..351.234 rows=11,827 loops=3)

  • Buffers: shared hit=12951 read=1294
9. 3.929 339.048 ↑ 1.0 11,827 3

Merge Join (cost=4.54..4,244.22 rows=11,827 width=55) (actual time=5.472..339.048 rows=11,827 loops=3)

  • Buffers: shared hit=12534 read=1090
10. 8.405 8.405 ↑ 1.0 11,827 3

Index Scan using mld_concordance_idx_marker_key on mld_concordance e (cost=0.29..805.62 rows=11,827 width=46) (actual time=0.008..8.405 rows=11,827 loops=3)

  • Buffers: shared hit=2736 read=149
11. 326.714 326.714 ↑ 17.6 43,836 3

Index Scan using mrk_marker_pkey on mrk_marker m (cost=0.42..56,215.06 rows=773,292 width=13) (actual time=5.287..326.714 rows=43,836 loops=3)

  • Buffers: shared hit=9798 read=941
12. 2.416 10.163 ↑ 1.0 23,256 3

Hash (cost=439.56..439.56 rows=23,256 width=8) (actual time=10.163..10.163 rows=23,256 loops=3)

  • Buffers: shared hit=417 read=204
13. 7.747 7.747 ↑ 1.0 23,256 3

Seq Scan on mld_expts x (cost=0..439.56 rows=23,256 width=8) (actual time=0.011..7.747 rows=23,256 loops=3)

  • Buffers: shared hit=417 read=204
14. 0.083 0.083 ↑ 1.0 1 11,827

Index Scan using bib_refs_pkey on bib_refs r (cost=0.42..1.27 rows=1 width=97) (actual time=0.083..0.083 rows=1 loops=11,827)

  • Index Cond: (r._refs_key = c._refs_key)
  • Buffers: shared hit=46943 read=367
15. 0.029 0.049 ↑ 1.0 293 3

Hash (cost=6.93..6.93 rows=293 width=4) (actual time=0.049..0.049 rows=293 loops=3)

  • Buffers: shared hit=12
16. 0.020 0.020 ↑ 1.0 293 3

Seq Scan on mgi_user u1 (cost=0..6.93 rows=293 width=4) (actual time=0.002..0.02 rows=293 loops=3)

  • Buffers: shared hit=12
17. 0.031 0.190 ↑ 1.0 293 3

Hash (cost=6.93..6.93 rows=293 width=4) (actual time=0.19..0.19 rows=293 loops=3)

  • Buffers: shared hit=10 read=2
18. 0.159 0.159 ↑ 1.0 293 3

Seq Scan on mgi_user u2 (cost=0..6.93 rows=293 width=4) (actual time=0.009..0.159 rows=293 loops=3)

  • Buffers: shared hit=10 read=2