explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qkAB

Settings
# exclusive inclusive rows x rows loops node
1. 0.129 6.145 ↑ 1.0 344 1

Unique (cost=4,826.68..4,829.26 rows=344 width=8) (actual time=5.955..6.145 rows=344 loops=1)

  • Buffers: shared hit=3775 read=1 dirtied=2
2. 0.193 6.016 ↑ 1.0 344 1

Sort (cost=4,826.68..4,827.54 rows=344 width=8) (actual time=5.954..6.016 rows=344 loops=1)

  • Sort Key: fa.facil_addr_id, faip.facil_addr_ins_plan_id
  • Sort Method: quicksort Memory: 41kB
  • Buffers: shared hit=3775 read=1 dirtied=2
3. 0.475 5.823 ↑ 1.0 344 1

Nested Loop (cost=1.28..4,812.18 rows=344 width=8) (actual time=3.212..5.823 rows=344 loops=1)

  • Buffers: shared hit=3775 read=1 dirtied=2
4. 0.279 4.660 ↑ 1.0 344 1

Nested Loop (cost=0.85..4,500.79 rows=344 width=8) (actual time=3.192..4.660 rows=344 loops=1)

  • Buffers: shared hit=2390 read=1 dirtied=1
5. 3.753 3.753 ↑ 1.0 314 1

Index Only Scan using facil_pkey on facil f (cost=0.42..1,889.92 rows=314 width=8) (actual time=3.180..3.753 rows=314 loops=1)

  • Index Cond: ((facil_id = ANY ('{1000907506,1000907510,1000907519,1000907521,1000907522,1000907524,1000907527,1000907552,1000907529,1000907532,1000907535,1000907537,1000907539,1000907540,1000907542,1000907545,1000907548,1000907549,1000907554,1000…907556,1000907558,1000907560,1000907562,1000907565,1000907566,1000907569,1000907570,1000907573,1000907574,1000907580,1000907577,1000907582,1000907513,1000907578,1000907583,1000907515,1000907531,1000907517,1000907536,1000907547,1000907561,1000907576,1000907508,1000907543,…1000907564,1000907584,1000907495,1000907526,1000907551,1000907572,1000907503,1000907504,1000907555,1000907567,1000907541,1000907501,1000907498,1000907512,1000907525,1000907533,1000907546,1000907559,1000907579,1000907489,1000907500,1000907523,1000907534,1000907550,1000907…568,1000907581,1000907485,1000907494,1000907507,1000907520,1000907530,1000907544,1000907563,1000907487,1000907516,1000907528,1000907538,1000907553,1000907571,1000907491,1000907492,1000907499,1000907514,1000907557,1000907575,1000907518,1000907502,1000907486,1000907496,100…0907497,1000907509,1000907488,1000907493,1000907511,1000907490,1000907505,1000907587,1000907589,1000907595,1000907602,1000907608,1000907611,1000907617,1000907624,1000907630,1000907637,1000907644,1000907648,1000907650,1000907654,1000907660,1000907662,1000907665,1000907668…,1000907671,1000907676,1000907683,1000907590,1000907597,1000907603,1000907609,1000907613,1000907619,1000907626,1000907632,1000907639,1000907645,1000907651,1000907657,1000907659,1000907663,1000907670,1000907678,1000907586,1000907593,1000907599,1000907605,1000907623,100090…7615,1000907622,1000907627,1000907634,1000907641,1000907646,1000907652,1000907667,1000907674,1000907681,1000907600,1000907635,1000907643,1000907653,1000907664,1000907672,1000907592,1000907606,1000907628,1000907640,1000907656,1000907669,1000907596,1000907616,1000907638,10…00907647,1000907658,1000907666,1000907677,1000907684,1000907620,1000907631,1000907649,1000907661,1000907675,1000907680,1000907594,1000907607,1000907618,1000907673,1000907682,1000907591,1000907604,1000907614,1000907633,1000907642,1000907585,1000907598,1000907610,100090762…1,1000907629,1000907655,1000907636,1000907679,1000907588,1000907601,1000907612,1000907625,1000907691,1000907695,1000907701,1000907706,1000907697,1000907685,1000907702,1000907707,1000907708,1000907692,1000907720,1000907733,1000907688,1000907699,1000907704,1000907783,10009…07689,1000907705,1000907713,1000907718,1000907724,1000907732,1000907737,1000907753,1000907772,1000907779,1000907686,1000907700,1000907710,1000907714,1000907717,1000907723,1000907728,1000907735,1000907739,1000907758,1000907784,1000907696,1000907709,1000907722,1000907726,1…000907730,1000907736,1000907747,1000907766,1000907782,1000907693,1000907703,1000907712,1000907716,1000907725,1000907729,1000907755,1000907742,1000907765,1000907776,1000907774,1000907777,1000907721,1000907746,1000907751,1000907756,1000907762,1000907767,1000907780,10009077…73,1000907687,1000907711,1000907727,1000907741,1000907745,1000907752,1000907757,1000907761,1000907690,1000907731,1000907740,1000907744,1000907749,1000907754,1000907760,1000907764,1000907769,1000907771,1000907781,1000907694,1000907715,1000907734,1000907743,1000907748,1000…907750,1000907759,1000907763,1000907768,1000907770,1000907775,1000907778,1000907698,1000907719,1000907738,1000907792,1000907797,1000907786,1000907791,1000907795,1000907798,1000907789,1000907793,1000907785,1000907788,1000907796,1000907787,1000907790,1000907794}'::integer[…])) AND (dw_id = 44))
  • Heap Fetches: 314
  • Buffers: shared hit=1130 read=1
6. 0.628 0.628 ↑ 1.0 1 314

Index Scan using facil_addr_fkidx on facil_addr fa (cost=0.42..8.30 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=314)

  • Index Cond: ((facil_id = f.facil_id) AND (dw_id = 44))
  • Buffers: shared hit=1260 dirtied=1
7. 0.688 0.688 ↑ 1.0 1 344

Index Scan using facil_addr_ins_plan_fkidx on facil_addr_ins_plan faip (cost=0.43..0.90 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=344)

  • Index Cond: ((facil_addr_id = fa.facil_addr_id) AND (dw_id = 44))
  • Buffers: shared hit=1385 dirtied=1
Planning time : 3,494.657 ms
Execution time : 6.337 ms