explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 75fi

Settings
# exclusive inclusive rows x rows loops node
1. 22,735.893 263,637.100 ↑ 599.7 234 1

Hash Left Join (cost=682,440.15..1,994,739.11 rows=140,333 width=56) (actual time=206,655.640..263,637.100 rows=234 loops=1)

  • Hash Cond: (cd.content_url_id = cu.id)
2. 133,359.891 240,901.207 ↑ 599.7 234 1

Hash Join (cost=347,137.24..1,618,130.13 rows=140,333 width=48) (actual time=197,717.383..240,901.207 rows=234 loops=1)

  • Hash Cond: (np.long_value = cd.id)
3. 6,276.727 6,276.727 ↑ 599.7 234 1

Index Scan using fk_alf_nprop_n on alf_node_properties np (cost=0.57..1,193,961.97 rows=140,333 width=8) (actual time=2.107..6,276.727 rows=234 loops=1)

  • Index Cond: (node_id = ANY ('{17186184,17186261,17186527,17186557,17186713,17323510,17323525,17323543,17323551,17323560,17323573,17323586,17323606,17734246,17734263,17734281,17734291,17734306,17734320,17734339,17734355,17734380,17734392,17734408,17734426,17734441,17734463,17734475,17734496,17734508,17734528,17734537,17734555,17734565,17734590,17734614,17734636,17734663,17734676,17734689,17734711,17734731,17734748,17734767,17734791,17734808,17734821,17734832,17734852,17734867,17734884,17734909,17734928,17734950,17734964,17734989,17735013,17735037,17735053,17735077,17735110,17735121,17735143,17735161,17735187,17735205,17735225,17735243,17735264,17735280,17735294,17735311,17735335,17735354,17735372,18224091,18224122,18224133,18224149,18224173,18224192,18224201,18224216,18224236,18224249,18224273,18224290,18224303,18224312,18224324,18224338,18224356,18224372,18224392,18224410,18224436,18224459,18224472,18224486,18224516,18224546,18224567,18224592,18224616,18224633,18224658,18224670,18224695,18224710,18667893,18925158,18925180,18925227,18925253,18925272,19739307,19739331,19739377,19739399,19739426,19739486,19739588,19739619,19739650,19739676,19739695,19739754,19739864,19739893,19739920,19739947,19739971,19739983,19740007,19740029,19740082,19740193,19740226,19740468,19740484,19740571,19740604,19740634,19740699,19740724,19740756,19740808,19740829,19740864,19740930,19740956,19741040,19741070,19741099,19741206,19741251,19741410,19741416,19741434,20068940,20068961,20068977,20068992,20069005,20069019,20069032,20069045,20069057,20069070,20069081,20069093,20069108,20069123,20069138,20069153,20069159,20069174,20069189,20069195,20069212,20069228,20069238,20069267,20069294,20069306,20069352,20069368,20069379,20069400,20069412,20069432,20069454,20439426,20439429,20439432,20439435,20439439,20439442,20439445,20439448,20439451,20439454,20439457,20439460,20439463,20439466,20439469,20439472,20439475,20603653,20603677,20603692,20603716,20603740,20603761,20893283,20893307,20893320,20893342,20893369,20893443,20893462,20893508,20893645,20893666,20893684,20893778,20893802,20893829,20893850,20893865,20893888,20893905,20903498,20903529,20904266}'::bigint[]))
  • Filter: ((actual_type_n = 3) OR (actual_type_n = 21))
  • Rows Removed by Filter: 7080
4. 100,237.313 101,264.589 ↓ 1.0 8,287,386 1

Hash (cost=170,857.52..170,857.52 rows=8,280,252 width=48) (actual time=101,264.589..101,264.589 rows=8,287,386 loops=1)

  • Buckets: 131072 Batches: 128 Memory Usage: 6086kB
5. 1,027.276 1,027.276 ↓ 1.0 8,287,386 1

Seq Scan on alf_content_data cd (cost=0.00..170,857.52 rows=8,280,252 width=48) (actual time=0.016..1,027.276 rows=8,287,386 loops=1)